Data Warehouse Interview Questions
Questions Answers Views Company eMail

Different sorts of metadata that stores in the storage facility?

546

How might you approve all mappings in the archive all the while?

592

Quickly characterize reusable change?

676

What do you mean by channel change?

529

What is abap? What are idocs?

504

How can we use external procedural logic in informatica?

524

Do we need an etl tool?

542

What is etl process. How many steps etl contains explain with example?

507

What is a staging area? What is the purpose of a staging area?

481

What are vaious etl tools in the market?

557

What are the measure objects?

647

What are the different types of transformation available in informatica.

620

Explain what are the different types of transformation available in informatica.

561

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

596

How to do unit testing in informatica? How to load data in informatica ?

637


Un-Answered Questions { Data Warehouse }

What is the difference between round-robin partitioning and hash partitioning?

542


Explain the architecture of obiee and what each components do?

481


explain the key concept of sas? : Sas-administrator

550


What is surrogate key? Where we use it explain with example?

478


what is the use of proc sql? : Sas programming

580






What is an Integration service in Informatica?

693


what are the different authentication modes available in microstrategy?

577


What is a predefined event?

648


How do you load only null records into target? Explain through mapping flow.

1488


What are all the types of indexes in Cognos?

704


What is a repository? And how to add it in an informatica client?

638


List few etl bugs?

515


what is granularity in Data ware House?

1158


How would you load a very large file in teradata in general?

553


How does microstrategy object manager integrate with the microstrategy product suite security model?

546