Icon

FAR_​Primary_​Sales_​Acct

This workflow is to create and load the data to FAR_Primary_Sales_Acct from the table [PRODUCT_REVENUE_DISTRIBUTION] Note : This is one of the intermiate process for creating the FAR Sales Trx table. Create intermidate table FAR_Primary_Sales_Acct to get the deferred account Main table will take place to process the FAR_SALES_TXN which loads incrementally. Temp table FAR_Sales_TrxTable CreationConnect IMAPROD_P360Connect IMADWNode 40Read Convert PRODUCT_IDfrom Double to IntTemp table FAR_Sales_TrxTable CreationNode 46Read Node 48Node 49 DB Insert DB Table Creator Microsoft SQLServer Connector Microsoft SQLServer Connector DB Table Selector DB Reader Double to Integer DB Insert DB Table Creator DB Table Selector DB Reader DB SQL Executor DB SQL Executor This workflow is to create and load the data to FAR_Primary_Sales_Acct from the table [PRODUCT_REVENUE_DISTRIBUTION]Note : This is one of the intermiate process for creating the FAR Sales Trx table. Create intermidate table FAR_Primary_Sales_Acct to get the deferred account Main table will take place to process the FAR_SALES_TXN which loads incrementally. Temp table FAR_Sales_TrxTable CreationConnect IMAPROD_P360Connect IMADWNode 40Read Convert PRODUCT_IDfrom Double to IntTemp table FAR_Sales_TrxTable CreationNode 46Read Node 48Node 49DB Insert DB Table Creator Microsoft SQLServer Connector Microsoft SQLServer Connector DB Table Selector DB Reader Double to Integer DB Insert DB Table Creator DB Table Selector DB Reader DB SQL Executor DB SQL Executor

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Vasantha.Paramasivan
Created at: 2024-11-15
On NodePit since: 2024-11-23
Last update: 2024-11-29
Created with KNIME version: v5.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!