What are materialized views & where do we use them? What is a materialized view?

1

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?

1

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

1

What is a staging area? Do we need it?

1

How to determine what records to extract?

1

What are the various tools? - Name a few?

1

What are materialized views & where do we use them? What is a materialized view log?

1

What are parameter files? Where do we use them?

1

What is the purpose of a staging area?

1

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1

What are active transformation / passive transformations?

1

When do you analyze the tables?

1

Where do we use connected and un connected lookups?

1

How do you analyze the tables

1

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

1