ETL (Extract, transform, load) Question: Download Extract, transform, load (ETL) PDF
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
Answer:
There are various ways of Extracting Data from Source Systems.For example , You can use a DATA step, an Import Process .It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru an ODS stmt/export stmt/FILE stmt, again which depends on the file & data format ,You want your output to be in.