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

What are stage variables?

1207

What are orabulk and bcp stages?

1128

What is datastage engine?

1183

How do u convert the columns to rows in datastage?

1195

What all the types of jobs you developed?

1181

What all are the different way to run a job?

1096

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

What is datastage?

1088

What are the main features of datastage?

1285

What is the difference between hashfile and sequential file?

1263

Where the datastage stored his repository?

1089

What is merge stage?

1318

What is container and then types?

1 1783

What are the functions used for character handling?

1261

What is proc sort?

1228

Un-Answered Questions { Data Warehouse }

Explain microstrategy logical primary keys?

1000

What are the types of facts in microstrategy?

1032

Have you worked with/created Parameter file

1667

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2538

Write the unconnected lookup syntax?

1085

What is the difference b/w macros and prompt?

1138

Explain the parallel data extension in teradata?

1101

What is a relationship?

997

What are the available primary index types?

1222

What are the steps involved after the disk manager passes the request?

1122

what does the run statement do? : Sas programming

1060

Explain lookup transformation source types in informatica

1102

What is Metrics designer?

1029

What are the considerations regarding performance kept in mind while setting up cognos?

969

What are the new features of Power Center 5.0?

1780

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