Interested to Buy Any Domain ? << Click Here >> for more details...
What are parameter files? Where do we use them?
- 1 Answers
- 26 Views
- I also Faced
- E-Mail Answers
Answer / Mahesh Singh
{"parameter files": "Parameter files in ETL are external files that contain values to be substituted into SQL statements or other configuration items. They allow you to easily change parameters without modifying the ETL code itself. Parameter files are commonly used for variables like database connection details, data transformation rules, and scheduling information."
| Is This Answer Correct ? | 0 Yes | 0 No |
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?
How do you analyze the tables
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
What is the purpose of a staging area?
How to determine what records to extract?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What are active transformation / passive transformations?
What is a staging area? Do we need it?
What are materialized views & where do we use them? What is a materialized view?
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?
Oracle General 
