DSXchange

how do we develop parameter driven ETL process to map source systems to target data warehouse with datastage complete source system profiling?

Hello Harithay,

The simple answer to your question

how do we develop parameter driven ETL process to map source systems to target data warehouse with DataStage complete source system profiling?

is as follows:

"You take the source data, transform, fix and move it into the target databases and keep detailed records of metadata and your actions".

This is probably going to be the most useful answer you are going to get from this forum.

Just as you have asked several rather all-encompassing questions in other forums recently, this one is impossible to answer in any useful way. So much for the free portion of the advice. Usually companies hire experts or consultants to solve this question for their specific implementation. Coincidentally there are a large number of people here who earn their living solving your question, and if you post the question in the "Looking for Talent" you will certainly get a number of responses from experts who will quote their daily rates and show an impressive record of solving your question for numerous clients.