ETL (Extract, transform, load) Interview Question:

Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?

Submitted by: Administrator

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.
Submitted by: Administrator