Hello Suraj, Thanks for the video on Dataflow. In the above scenario, the resultant target is shown as an Order details summary that already exists in the repository. But my question is the resultant data must be stored in the new local table as a Target right?? Can you please clarify on this? How can we consider an already existing table as our target?
hi Charan, the target table can be an existing table or you can create a new table in dataflow itself as target table. For instance you created a fact table from scratch with no data, now you need to design a data flow which will update data to this new table, which means it will be an existing table from repository and you can select required update mode (update, truncate, delete). Hope this clarifies your doubt
@@SurajYTech So here that existing table (which we created as a Fact table) will be the output/ Target table. AND we consider the mode as Append since we are updating the data to this table. Let me know whether I understood correctly. So if APPEND will do this functionality. Then how does TRUNCATE and DELETE modes are helpful here? Can you explain this with a small example?
Hello Suraj,
Thanks for the video on Dataflow. In the above scenario, the resultant target is shown as an Order details summary that already exists in the repository. But my question is the resultant data must be stored in the new local table as a Target right?? Can you please clarify on this? How can we consider an already existing table as our target?
hi Charan, the target table can be an existing table or you can create a new table in dataflow itself as target table. For instance you created a fact table from scratch with no data, now you need to design a data flow which will update data to this new table, which means it will be an existing table from repository and you can select required update mode (update, truncate, delete). Hope this clarifies your doubt
@@SurajYTech So here that existing table (which we created as a Fact table) will be the output/ Target table. AND we consider the mode as Append since we are updating the data to this table. Let me know whether I understood correctly. So if APPEND will do this functionality. Then how does TRUNCATE and DELETE modes are helpful here? Can you explain this with a small example?