Data Warehousing Interview Questions - I

Monday, November 26, 2007

1) What is source qualifier?
2) Difference between DSS & OLTP?
3) Explain grouped cross tab?
4) Hierarchy of DWH?
5) How many repositories can we create in Informatica?
6) What is surrogate key?
7) What is difference between Mapplet and reusable transformation?
8) What is aggregate awareness?
9) Explain reference cursor?
10) What are parallel querys and query hints?
11) DWH architecture?
12) What are cursors?
13) Advantages of de normalized data?
14) What is operational data source (ODS)?
15) What is meta data and system catalog?
16) What is factless fact schema?
17) What is confirmed dimension?
18) What is the capacity of power cube?
19) Difference between PowerPlay transformer and power play reports?
20) What is IQD file?


ramesh November 26, 2007 at 11:09 AM  

sorragate key or warehouse key is a sequence generate key which is asigned to be a primary key in the table.

Post a Comment


About This Blog


  © Blogger template The Professional Template II by 2009

Back to TOP