Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is InformaticaPowerCenter?

Informatica,

786

What are the designer tools for creating transformations?

Informatica,

774

In which transformation you cannot drag ports into it?

Informatica,

908

What are the different transaction levels available in transaction control transformation?

Informatica,

753

What is the difference between Active and Passive transformation?

Informatica,

736

How to convert multiple rows to single row (multiple columns) in informatica

Informatica,

1015

Explian the Process of deployment groups in informatica

Informatica,

730

What are the components of Informatica? And what is the purpose of each?

Informatica,

693

How to create a non-reusable instance of reusable transformations?

Informatica,

782

Explain informatica architecture - version 8 / 9

Informatica,

757

Explain transaction control transformation in informatica

Informatica,

906

Explain pmcmd command usage in informatica

Informatica,

796

What are 2 modes of data movement in Informatica Server?

Informatica,

1 1000

Explain pushdown optimization $pushdownconfig parameter - informatica

Informatica,

810

What is a passive transformation?

Informatica,

726


Un-Answered Questions { Data Warehouse }

What are initial page components of Cognos connection?

690


What is the order of precedence of vldb properties?

650


What does role playing dimension mean?

714


What are intelligent cubes?

670


How will you port changes for dashboards,reports,rpd from development to production?

590






What is publickey and private key?what is the use of this two keys?

2459


Can you run multiple rpd’s in a single obiee instance?

500


What are the different options associated with dsjob command?

1081


Why are oltp database designs not generally a good idea for a data warehouse?

698


project Steps,hits, Project level HArd things,Solved methods?

1707


What is the maximum length of the macro variable?

787


what are the different types of fact structures?

638


After we create a scd table, can we use that particular dimension as a dimension table for star schema?

637


How a server job can be converted to a parallel job?

716


Briefly describe lookup transformation?

667