Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 5797

Difference between DSS & OLTP?

IBM,

6 35140

Explain grouped cross tab?

1430




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13763

How many repositories can we create in Informatica?

Informatica,

14 16231

What is surrogate key?

IBM,

5 15561

What is difference between Mapplet and reusable transformation?

UST,

3 2674

What is aggregate awareness?

2 4617




Explain reference cursor?

975

What are parallel querys and query hints?

1076

DWH architecture?

6 11931

What are cursors?

4 4755

Advantages of de normalized data?

2 8210

What is operational data source (ODS)?

2 6898

What is meta data and system catalog?

1005


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

What is difference macros and prompts?

959


Compare and contrast aggregates & indexes

2489


Explain clustering algorithm?

947


How are models actually derived?

808


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.

825






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

1236


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

2936


in general which algorithms for used?

780


What is Analysis Services?

939


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

842


Can decision tree be implemented using SQL?

856


Compare aggregates and data marts

1416


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

4663


what are the all possible features supported modify stage?

852


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

839