Interested to Buy Any Domain ? << Click Here >> for more details...
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
1I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
1What are snapshots? 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?
What are the various tools? - Name a few?
What are parameter files? Where do we use them?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
When do you analyze the tables?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What is the purpose of a staging area?
What are materialized views & where do we use them? What is a materialized view log?
What are active transformation / passive transformations?
How to determine what records to extract?
Where do we use connected and un connected lookups?
What are materialized views & where do we use them? What is a materialized view?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
How do you analyze the tables
What is a staging area? Do we need it?
