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?

Tweet Share WhatsApp

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.

Download Extract, transform, load (ETL) PDF Read All 37 Extract, transform, load (ETL) Questions
Previous QuestionNext Question
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?Explain What are the various transformation available?