Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

1 4401

Difference between DSS & OLTP?

IBM,

5 24107

Explain grouped cross tab?

1182

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 11425

How many repositories can we create in Informatica?

Informatica,

14 13055

What is surrogate key?

IBM,

5 12205

What is difference between Mapplet and reusable transformation?

UST,

3 1558

What is aggregate awareness?

2 3534

Explain reference cursor?

767

What are parallel querys and query hints?

839

DWH architecture?

6 9837

What are cursors?

4 3802

Advantages of de normalized data?

2 7033

What is operational data source (ODS)?

2 5346

What is meta data and system catalog?

769


Post New Data Warehouse General Questions


Un-Answered Questions { Data Warehouse General }

Can decision tree be implemented using SQL?

627


if you use oracle sql*loader , how do you transform data with it during loading?

654


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

996


How to handle multi value dimensions?

753


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

934


What is Discrete and Continuous data in Data mining world?

920


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.

569


What are different deliverables according to phases?

1851


what are the all possible features supported modify stage?

597


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

709


what is user variable in affinium campaign? and some real time examples.

2704


What is Discover and Execute in XMLA?

817


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

940


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

4004


What is MODEL is Data mining world?

1145