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 Star Schema?

Informatica,

1111

What are the types of SCD?

1198

What is VLDB?

1066

What are Aggregate tables?

1179

What are loops in Datawarehousing?

1001

How can we load the time dimension?

1200

What is a core dimension?

1071

What are Non-additive facts?

1169

What is real-time datawarehousing?

1028

What is Active Datawarehousing?

1019

What is the difference between Datawarehouse and OLAP?

923

What is called data cleaning?

1241

What is factless fact tables?

1212

Name validation tools used in SAS

1184

What is the SAS data set?

1136

Un-Answered Questions { Data Warehouse }

Explain can report net connect multiple datasource at a time in report creation time?

931

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

1010

Explain the different kinds of facts.

984

If RDBMS is halted what will you do ?

2170

What is amazon redshift?

what is sas application server? : Sas-di

1083

How to clean the datastage repository?

1127

What is the basic structure of a sas program?

1124

explain abt ur project architecture?

2197

what is mean by complex business rule ?

2162

How many types of stage?

1181

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1071

What is informatica powercenter repository?

1204

What are the differences between sql override and update override?

1102

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