How do you load the data conditionally by run steps ?

Showing Answers 1 - 3 of 3 Answers

DWH01

  • Jul 8th, 2008
 

This depends upon how the ETL is done:

If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in which the scripts could check for the conditions. 

When using Oracle SQL Loader or Oracle External tables,  we can check for the conditions in scripts or in the database by running SQL Scripts or SPs.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions