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:
Informatica
Data Stage
Oracle Warehouse Bulider
Ab Initio
Data Junction

(Continued on next question...)

Other Job Interview Questions

• What is fact less fact table? where you have used it in your project?
• What is a linked cube?
• How do you load the time dimension?
• Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.
• what is the datatype of the surrgate key ?
• Can a dimension table contains numeric values?
• What is hybrid slowly changing dimension?
• What is the difference between Datawarehousing and BusinessIntelligence?
• What's the data types present in bo?n what happens if we implement view in the designer n report
• What is ER Diagram?
• More...