Data Warehouse General Interview Questions
Questions Answers Views Company eMail

What is source qualifier?

2 6515

Difference between DSS & OLTP?

IBM,

6 39204

Explain grouped cross tab?

1619




Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14744

How many repositories can we create in Informatica?

Informatica,

14 17833

What is surrogate key?

IBM, Informatica,

5 16862

What is difference between Mapplet and reusable transformation?

UST,

3 3452

What is aggregate awareness?

2 5150




Explain reference cursor?

1159

What are parallel querys and query hints?

1253

DWH architecture?

6 12922

What are cursors?

4 5254

Advantages of de normalized data?

2 8825

What is operational data source (ODS)?

2 7526

What is meta data and system catalog?

1292


Post New Data Warehouse General Questions






Un-Answered Questions { Data Warehouse General }

Is union transormation is active transformation?

13


What are fundamental stages of data warehousing?

5


Explain a linked cube?

11


What do you mean by static and local variable?

9


What are session timeout and application timeout? Where we have to do this process?

8






What is a linked cube?

12


What is data stream and data adaopter. Is it same are different? Explain?

15


Ist the schema that a data warehouse system can implements.

11


Explain functional dependency?

13


Explain what are data marts?

13


Explain what is full load & incremental or refresh load?

8


How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

12


Explain what are slowly changing dimensions?

15


What a static and local variable?

14


Explain clustering algorithm?

1148