Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are parallel querys and query hints?

1778

DWH architecture?

6 16088

What are cursors?

4 7340

Advantages of de normalized data?

2 10220

What is operational data source (ODS)?

2 9293

What is meta data and system catalog?

1844

What is factless fact schema?

2 5650

What is confirmed dimension?

JPMorgan Chase,

7 13963

What is the capacity of power cube?

2 5728

Difference between PowerPlay transformer and power play reports?

CTS,

2055

What is IQD file?

1 4774

What is Cognos script editor?

2067

What is difference macros and prompts?

1705

What is power play plug in?

3 3637

Which kind of index is preferred in DWH?

1 7888


Un-Answered Questions { Data Warehouse }

What are the processing stages?

633


How many input parameters can exist in an unconnected lookup?

978


Write the unconnected lookup syntax and how to return more than one column.

585


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

571


What are batches?

607






What is difference between join, merge and lookup stage?

630


What are the different types of datawarehosuing?

552


Does an informatica transformation support only aggregate expressions?

600


What is an expression transformation?

583


What is run-group processing?

610


What is persistent lookup cache?

591


Differences between business objects and web intelligence reports?

647


what is pmrep command?

1946


Where is tm1 web logging information found?

5


can you please explain me pre session and post session options?

6345