Oracle Extract transform load (ETL) Question:
Download Questions PDF

I am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling 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.

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?