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 is the difference between router and filter?

1269

Can you highlight the main features of ibm infosphere information server?

1088

What are the areas of application?

1151

What is job control?

1112

What is the precedence of stage variables,derivations, and constraints?

1086

What could be a data source system?

1008

What a datastage macro?

1060

Why do you need stage variables?

1180

On which interface you will be working as a developer?

1042

What are data elements?

1173

What is the difference between in process and inter process?

1147

Highlight the main features of datastage?

1160

What are the types of hashed files in data stage

1108

What is difference between server jobs & parallel jobs?

1038

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

Un-Answered Questions { Data Warehouse }

What is $mpjret?

1150

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149

What are junk dimensions?

1072

Have you ever used the SAS Debugger?

1759

How will you enable or disable caching in the system level and table level?

894

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

What are the different functions performed in development phase?

1080

Difference between nodup and nodupkey options?

1195

can metadata be manually edited? If yes, how?

1028

What are the difference between the sas data step and sas procs?

1187

How we can use union transformation?

1051

How abinitio eme is segregated?

1281

what is Forward,Reverse and Re_engineering?

2196

how to connect datamarts

2791

How many steps etl contains explain with example?

970

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