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)?

1068

Explain dimension table ?

1043

What is bi?

1185

Explain is fact table?

980

What is difference between content store and content manager?

1030

What is difference between informatica power mart and power center?

1054

What are the batches and it’s details?

1027

Explain difference between powerplay transformer and power play reports?

1002

What is metric store database?

1046

Explain informatica architecture?

1053

Define cognos report net?

1014

What is difference between data mart and data warehouse?

1021

How to join multiple db in catalog?

1070

How do you call a store procedure within a transformation?

1055

Different circumstance which drives informatica server to expel records?

1047

Un-Answered Questions { Data Warehouse }

What would you change about your job?

2449

How we can scale Reshift database?

Quickly characterize reusable change?

1186

Give some examples where proc report’s defaults are same as proc print’s defaults?

1168

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

1189

Mention what is a partition and what are the different types of partition components in abinitio?

1232

Explain datastage architecture?

1453

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2538

What are attribute roles?

1030

What the difference is between a database, a data warehouse and a data mart?

1203

What are the co> operating system’s assorted library of integrated components?

1168

What is the basic syntax for teradata select statement?

1102

Clarify the utilization of aggregator cache record?

1045

What is MAX CORE of a component?

1371

What are the components of workflow manager?

1163

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