Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4854

Difference between DSS & OLTP?

IBM,

5 28636

Explain grouped cross tab?

1276




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12332

How many repositories can we create in Informatica?

Informatica,

14 14351

What is surrogate key?

IBM,

5 13316

What is difference between Mapplet and reusable transformation?

UST,

3 1951

What is aggregate awareness?

2 3952




Explain reference cursor?

817

What are parallel querys and query hints?

906

DWH architecture?

6 10575

What are cursors?

4 4099

Advantages of de normalized data?

2 7486

What is operational data source (ODS)?

2 5871

What is meta data and system catalog?

850


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

655


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

852


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

973


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

693


what are the all possible features supported modify stage?

698


what are the others of "bad files" and "discard files" when using sql*loader?

668


Is there any difference in testing database and data ware housing?

1040


What are the different problems that ?Data mining? can solve?

984


What is Cognos script editor?

950


can anybody mail me the FAQS for hyperion essbase amd planning

4231


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

633


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

4209


Compare aggregates and data marts

1228


what are the other factors of the database on which the loading performance depend?

537


what is parallel query?

622