What are the vaious ETL tools in the Market?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the vaious ETL tools in the Market?

Various ETL tools used in market are:

1. Informatica
2. Data Stage
3. MS-SQL DTS(Integrated Services 2005)
4. Abinitio
5. SQL Loader
6. Sunopsis
7. Oracle Warehouse Bulider
8. Data Junction

(Continued on next question...)

Other Job Interview Questions

• What is degenerate dimension table?
• Which columns go to the fact table and which columns go the dimension table?
• What is the Difference between OLTP and OLAP?
• Why is Data Modeling Important?
• What are modeling tools available in the Market?
• Why fact table is in normal form?
• What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
• What is the main difference between Inmon and Kimball philosophies of data warehousing?
• What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
• Name some of modeling tools available in the Market?
• More...