Data Warehouse Interview Questions
Questions Answers Views Company eMail

Why sorter is an active transformation?

Informatica,

840

Under which circumstances, informatica server creates reject files?

Informatica,

681

Explain the pipeline partition with real time example?

Informatica,

750

What is the need of an ETL tool?

Informatica,

729

What are the types of lookup transformation?

Informatica,

724

Explain pushdown optimization and types in informatica

Informatica,

747

What is a sorter transformation?

Informatica,

780

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

Informatica,

902

What is a connected transformation?

Informatica,

780

what is the Default Source Option For Update Strategy Transformation?

Informatica,

853

Can we use the mapping parameters or variables created in one mapping into another mapping?

Informatica,

1 1703

What are connected or unconnected transformations?

Informatica,

721

How can a transformation be made reusable?

Informatica,

749

Can u generate reports in Informatica?

Informatica,

731

What is the Process to creating lookup transformation in informatica

Informatica,

678


Un-Answered Questions { Data Warehouse }

How do you import and export the datastage jobs?

825


Can you define drill across?

643


What are the different type of jobs in datastage?

714


What is the purpose of interprocessor stage in server jobs?

1828


What are the steps involved in etl process?

598






Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1524


what are the deliverables?in your project?

1769


what is sas application server? : Sas-di

619


---------------Describe OLAP Reporting and RDBMS Reporting?

1759


What is the difference between connected and unconnected stored procedures?

649


How can you write parallel routines in datastage PX?

702


On which Dimension Table you implemented SCD Type in your Project

1683


What’s the difference between var b1 – b3 and var b1 — b3?

942


How can one identify whether mapping is correct or not without connecting session?

1015


What is level metrics in microstrategy?

645