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

Differentiate between data file and descriptor file?

1112

How to manage date conversion in Datastage?

1199

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

1150

What is the difference between Datastage 7.5 and 7.0?

1160

Differentiate between validated and Compiled in the Datastage?

1370

Name the different types of Lookups in Datastage?

1316

Differentiate between datastage and informatica?

1254

What are the steps required to kill the job in Datastage?

1280

How can you write parallel routines in datastage PX?

1078

Define Data Stage?

1148

Define APT_CONFIG in Datastage?

1139

Differentiate between Join, Merge and Lookup stage?

1148

What is the method of removing duplicates, without the remove duplicate stage?

1091

Define Routines and their types?

1271

Define Job control?

1240

Un-Answered Questions { Data Warehouse }

Can you define cube?

1098

Explain what is type 2 version dimension?

1071

What are the fundamental elements of the data warehouse?

1061

How to elaborate tracing level?

1225

What is a shortcut and copy in Informatica and how two are different with each other?

1255

How can you import tables from a database?

1171

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2401

What is the basic structure of a sas program?

1179

Briefly describe lookup transformation?

1101

How do you create surrogate key using ab initio?

1060

What are the types of studio present in Cognos?

1087

How to create prompts in report net?

1055

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1192

What is dynamic aggregation in microstrategy?

1034

Have you worked with packages?

1289

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