Data Warehouse Interview Questions
Questions Answers Views Company eMail

Different sorts of metadata that stores in the storage facility?

564

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

603

Quickly characterize reusable change?

695

What do you mean by channel change?

549

What is abap? What are idocs?

516

How can we use external procedural logic in informatica?

528

Do we need an etl tool?

559

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

519

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

496

What are vaious etl tools in the market?

583

What are the measure objects?

668

What are the different types of transformation available in informatica.

641

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

576

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

609

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

655


Un-Answered Questions { Data Warehouse }

Explain vldb?

633


What is dimensional table? Explain the different dimensions.

667


What is loop in data warehousing?

685


What is the difference between a data mart and a data warehouse?

548


What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

494






Explain what are fact, dimension, and measure?

559


what is star schema? : Sas-di

649


Difference between data warehousing and olap?

655


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5268


Write the advantages of partitioning a session?

753


What is the opening step in basic teradata query script?

600


What do you mean by dimensional modeling and relational modeling?

502


What is the scenario which compels informatica server to reject files?

608


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2154


Which component has onread method and what it is used for?

515