Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various tools? - Name a few?
- 1 Answers
- 32 Views
- I also Faced
- E-Mail Answers
Answer / Mukesh Chandra
{"tools": "There are numerous ETL tools available, each with its own strengths and weaknesses. Some popular ones include Informatica PowerCenter, IBM InfoSphere DataStage, Microsoft SQL Server Integration Services (SSIS), Talend Data Integration, Pentaho Data Integration, and SAS Data Integration Studio."
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a staging area? Do we need it?
Where do we use connected and un connected lookups?
What are materialized views & where do we use them? What is a materialized view log?
What are the various tools? - Name a few?
What is the purpose of a staging area?
How to determine what records to extract?
What are parameter files? Where do we use them?
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?
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?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
How do you analyze the tables
Oracle General 
