What are materialized views & where do we use them? What is a materialized view?
What is a staging area? Do we need it?
When do you analyze the tables?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
What are parameter files? Where do we use them?
What is the purpose of a staging area?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What are active transformation / passive transformations?
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?
What are the various tools? - Name a few?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Where do we use connected and un connected lookups?
How to determine what records to extract?
What are materialized views & where do we use them? What is a materialized view log?
How do you analyze the tables