Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 5922

Difference between DSS & OLTP?

IBM,

6 36041

Explain grouped cross tab?

1467




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13934

How many repositories can we create in Informatica?

Informatica,

14 16575

What is surrogate key?

IBM,

5 15804

What is difference between Mapplet and reusable transformation?

UST,

3 2810

What is aggregate awareness?

2 4708




Explain reference cursor?

1003

What are parallel querys and query hints?

1099

DWH architecture?

6 12103

What are cursors?

4 4831

Advantages of de normalized data?

2 8295

What is operational data source (ODS)?

2 7014

What is meta data and system catalog?

1036


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

what are different storage options supported by oracle ?

926


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

945


What is Discrete and Continuous data in Data mining world?

1370


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

1054


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 ??????

875






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

878


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

1568


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

4514


Can decision tree be implemented using SQL?

887


Compare and contrast aggregates & indexes

2531


How are models actually derived?

839


What is difference macros and prompts?

993


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

880


What are different deliverables according to phases?

2187


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

1076