|
Answer» ETL is extraction , transforming , loading process , you will extract data from the source and apply the business role on it then you will LOAD it in the TARGET The steps are : 1-DEFINE the source (create the odbc and the connection to the source DB) 2-define the target (create the odbc and the connection to the target DB) 3-create the mapping ( you will apply the business role here by adding transformations , and define how the data flow will go from the source to the target ) 4-create the SESSION (its a set of instruction that run the mapping ) 5-create the work flow (instruction that run the session) ETL is extraction , transforming , loading process , you will extract data from the source and apply the business role on it then you will load it in the target The steps are : 1-define the source (create the odbc and the connection to the source DB) 2-define the target (create the odbc and the connection to the target DB) 3-create the mapping ( you will apply the business role here by adding transformations , and define how the data flow will go from the source to the target ) 4-create the session (its a set of instruction that run the mapping ) 5-create the work flow (instruction that run the session)
|