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?

1268

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

1088

What are the areas of application?

1150

What is job control?

1111

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

1086

What could be a data source system?

1008

What a datastage macro?

1059

Why do you need stage variables?

1180

On which interface you will be working as a developer?

1042

What are data elements?

1171

What is the difference between in process and inter process?

1146

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?

1087

Un-Answered Questions { Data Warehouse }

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

Did you face any problems while creating reports? Name? Solutions?

3691

What are all the types of report?

1094

What are key differences between sql server and amazon redshift?

Explain degenerate dimension table?

1046

How security is concerned with Reportnet? Explain its implementing steps.

2043

Which columns go to the fact table and which columns go the dimension table?

961

What is a Query Subject?

1090

What is the sortmerge collector?

1130

What is the difference between datastage and informatica?

1118

What is mapping debugger?

1012

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1066

Explain Teradata performance tuning and optimization?

1162

What are the methodologies of data warehousing?

992

What is a Datastore in Cognos?

1286

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