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 operational data store (ods)?

1016

Explain dimension table ?

982

What is bi?

1092

Explain is fact table?

932

What is difference between content store and content manager?

976

What is difference between informatica power mart and power center?

1004

What are the batches and it’s details?

973

Explain difference between powerplay transformer and power play reports?

953

What is metric store database?

1000

Explain informatica architecture?

997

Define cognos report net?

974

What is difference between data mart and data warehouse?

978

How to join multiple db in catalog?

1015

How do you call a store procedure within a transformation?

1004

Different circumstance which drives informatica server to expel records?

983

Un-Answered Questions { Data Warehouse }

What is the difference between the proc sql and data step?

1174

How can you clear the cache?

1011

Does Amazon redshift based on concept cluster?

What is Indexing? how did u implement indexing?

2472

Differences between version 7.x and 8.x.

1893

how do you create schema objects in 2 tier connection?

953

What is defined as partial backup?

1075

How would you load a very large file in teradata in general?

1032

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

What is the difference between partitioning with key / hash and round robin?

1378

List out the file extensions used in abinitio?

1093

What is the purpose of trailing @ and @@? How do you use them?

1040

What are the different types of fact tables used in data warehousing?

993

Why might the optimizer use a table scan when an index is available?

2309

Define orabulk and bcp stages?

1122

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