|
INTERVIEW QUESTIONS
DATA WAREHOUSING
ETL
DETAILS
Question: Do we need an ETL tool? When do we go for the tools in the market?
Answer: ETL Tool: It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc). Need of ETL Tool: An ETL tool is typically required when data scattered accross different systems.(like RDBMS,Flat files,Mainframes,SAP,XML etc).
Submitted by Praveen Reddy.C ([email protected])
|
|
|
Category |
ETL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9309 users |
Added on |
5/21/2011 |
Views |
79834 |
Rate it! |
|
|
Question:
Do we need an ETL tool? When do we go for the tools in the market?
Answer:
ETL Tool: It is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc). Need of ETL Tool: An ETL tool is typically required when data scattered accross different systems.(like RDBMS,Flat files,Mainframes,SAP,XML etc).
Submitted by Praveen Reddy.C ([email protected]) Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?
|
View Answer
|
|
How to determine what records to extract?
|
View Answer
|
|
What is Full load & Incremental or Refresh load?
|
View Answer
|
|
Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)
|
View Answer
|
|
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
|
View Answer
|
|
What is partitioning? What are the types of partitioning?
|
View Answer
|
|
When do we Analyze the tables? How do we do it?
|
View Answer
|
|
Compare ETL & Manual development?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All ETL Interview Questions & Answers - Exam Mode /
Learning Mode
|