Data Warehouse Interview Questions
Questions Answers Views Company eMail

How we can create indexes after completing the load process?

859

What is the surrogate key?

798

Why is sorter an active transformation?

829

Define sessions in informatica etl?

743

Define filter transformation?

800

What is meant by a domain?

799

What is the benefit of partitioning a session?

804

Explain the difference between mapping parameter and mapping variable?

759

What are the various types of transformation?

812

Write the prerequisite tasks to achieve the session partition?

793

What is the reusable transformation?

792

What is meant by active and passive transformation?

743

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

1045

Define mapplet?

765

Explain the scenario which compels informatica server to reject files?

837


Un-Answered Questions { Data Warehouse }

Why should you put your data warehouse on a different system than your oltp system?

638


What is the difference between business requirement document and use case document.

731


Explain about alerts in bos, under what situation we need to use alerts?

720


What are the advantages of using informatica as an etl tool over teradata?

730


What can we do to improve the performance of informatica aggregator transformation?

793






Can reports be executed in off-peak periods?

722


How to load the data from a flat file into the target where the source flat file name changes daily?

732


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

643


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1929


What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

2972


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

693


How to do the error handling of if ur source is flatfiles?

1662


how do u set partition points in the mapping?

1914


What are the benefits of datastage?

874


What is the difference between absolute filtering and standard filtering in microstrategy?

709