Data Warehouse Interview Questions
Questions Answers Views Company eMail

How we can create indexes after completing the load process?

788

What is the surrogate key?

741

Why is sorter an active transformation?

758

Define sessions in informatica etl?

699

Define filter transformation?

718

What is meant by a domain?

741

What is the benefit of partitioning a session?

740

Explain the difference between mapping parameter and mapping variable?

705

What are the various types of transformation?

741

Write the prerequisite tasks to achieve the session partition?

737

What is the reusable transformation?

733

What is meant by active and passive transformation?

677

What is the difference between a repository server and a powerhouse?

941

Define mapplet?

706

Explain the scenario which compels informatica server to reject files?

751


Un-Answered Questions { Data Warehouse }

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10082


What is a partition and what are the different types of partition components in abinitio?

852


How can we Maintain the Cube Security by Category level and Dimension level ?

2040


Explain the methods to improve performance of a graph?

750


What are pre and post-session shell commands?

848






Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

832


What is the status code in stored procedure transformation?

765


What do you understand by the term 'aggregate advisor?'

629


what are the cubes developed in a sap bw project and what is the requirement for developing it?

1792


What is conformed fact?

725


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

1723


What is the cumulative sum and moving sum?

865


What is the difference in the way microstrategy handles custom group and consolidations?

653


What is the purpose of interprocessor stage in server jobs?

1828


What according to you might be the future of data warehousing?

625