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