Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are parallel querys and query hints?

1789

DWH architecture?

6 16191

What are cursors?

4 7386

Advantages of de normalized data?

2 10249

What is operational data source (ODS)?

2 9320

What is meta data and system catalog?

1855

What is factless fact schema?

2 5673

What is confirmed dimension?

JPMorgan Chase,

7 14026

What is the capacity of power cube?

2 5765

Difference between PowerPlay transformer and power play reports?

CTS,

2076

What is IQD file?

1 4796

What is Cognos script editor?

2075

What is difference macros and prompts?

1715

What is power play plug in?

3 3672

Which kind of index is preferred in DWH?

1 7908


Un-Answered Questions { Data Warehouse }

Write the prerequisite tasks to achieve the session partition?

652


I need to set predefined condition. How I do this?

506


what is the difference between list report and crosstab report?

715


Informatica settings are available in which file?

591


which date function advances a date, time or datetime value by a given interval? : Sas programming

602






what are the concerns of OLTP and DSS systems?

1973


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

518


What is the surrogate key?

644


Explain difference between view and materialized view?

507


What is informatica metadata and where is it stored?

591


How can I schedule reports in cognos?

599


What are components of report studio?

538


How to sort in descending order?

798


what is Forward,Reverse and Re_engineering?

1731


How do you truncate a table?

688