Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Distinguish between informatica & datastage. Which one would you choose and why?

1021

How do you import and export the datastage jobs?

1173

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1054

What are the steps needed to create a simple basic datastage job?

1249

What is informatica worklet?

1078

How to elaborate powercenter integration service?

1150

How can we use batches?

1039

What is rank transformation?

1000

What is rank index in rank transformation?

1093

What is aggregator transformation in informatica?

970

How you can differentiate between connected lookup and unconnected lookup?

1071

What is union transformation in informatica?

1154

How can we create index after completion of load process?

1135

What is mapplet in informatica?

1075

Enlist few areas or real-time situations where informatica is required.

1103

Un-Answered Questions { Data Warehouse }

What is the main difference between schema in rdbms and schemas in datawarehouse?

1102

Explain connectivity between datastage with datasources?

997

What is drilling across?

1008

What is the differences between star and snowflake schemas?

1082

How to elaborate powercenter integration service?

1150

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1028

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4121

CHANGE CAPTURE

1316

What are the different types of datawarehosuing?

1005

What is the difference in the way microstrategy handles custom group and consolidations?

1004

How to use pmcmd utility command?

1048

How can we use batches?

1039

What is the enterprise class platform architecture of cognos 8?

1041

How you know when to use a static cache and dynamic cache in lookup transformation?

1867

Explain the hierarchies level data warehousing.

902

For More Un-Answered { Data Warehouse } Questions Click Here