I am currently building a package in which I need to populate about 15 tables from a single staging table.I am planning to have 15 seperate DFT's which load each of 15 tables from a staging table.My requirement is
that once the package is executed and if there are any failed DFT's while executing the package, next time I need to execute those DFT's which are failed in the first run.
Do anybody have any suggestions to achieve this?
To achieve the above problem,what I am thinking is that I want to place all the DFT's in a sequence container and set the transaction option to TRUE.So,even a single DFT fails all of my DFT's will get rolled back.Is this a right approach?My input data
will be 3000 rows for each table.As I said I have one staging table populating 15 tables.I want to place all my 15 DFT's in a sequence container.
can you guys suggest me the better approach?
View Complete Post