Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6467

Difference between DSS & OLTP?

IBM,

6 38769

Explain grouped cross tab?

1593




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14671

How many repositories can we create in Informatica?

Informatica,

14 17625

What is surrogate key?

IBM, Informatica,

5 16745

What is difference between Mapplet and reusable transformation?

UST,

3 3376

What is aggregate awareness?

2 5106




Explain reference cursor?

1136

What are parallel querys and query hints?

1241

DWH architecture?

6 12834

What are cursors?

4 5214

Advantages of de normalized data?

2 8783

What is operational data source (ODS)?

2 7471

What is meta data and system catalog?

1268


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

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

1043


Can you brief about the Data warehouse project you worked on?

1356


What is a core dimension?

19


how much memory space occupied real time project (roughly)?

1246


what are relationships?

20






What is the purpose of Dataware Control?

18


What is the difference between agglomerative and divisive hierarchical clustering?

1


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

1354


What are the stages that are required in data warehousing?

1


What are the approaches used by optimizer during execution plan?

11


What is meta data and system catalog?

1268


What are the steps to build the datawarehouse?

11


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

1056


What is Sequence clustering algorithm?

956


What is the difference between Datawarehouse and OLAP?

19