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

Do we need an ETL tool? When do we go for the tools in the market?

1038

Compare ETL & Manual development?

1004

What are the different Lookup methods used in Informatica?

966

What are the types of Data Warehouse applications?

1085

What are the key benefits of ETL Testing?

1102

What is cube grouping?

1157

What is virtual Data Warehousing?

1036

What are the modules in Power Mart?

1022

Define slowly changing dimensions (SCD)?

1102

What is the difference between Data Warehousing and Data Mining?

1117

How one source columns or rows to be loaded in to two different tables?

1182

What is a merge?

1243

Why fact table is in normal form?

1313

Whats difference betweeen operational data stage (ods) and data warehouse?

1172

How the ipc stage work?

1171

Un-Answered Questions { Data Warehouse }

What is a bridge table ?

957

What can be achieved by using the teradata rdbms?

1092

What is Fullouterjoin?

2024

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2050

what versions of sas have you used (on which platforms)? : Sas programming

1135

What are iconv and oconv?

1305

In proc transpose and data step with arrays which one you pick?

3179

What is the difference between router and filter?

1380

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2156

What are the multiload utility limitations?

1117

What dedup-component and replicate component does?

1327

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2445

Difference between informatica vs ab initio?

1376

Why do you need stage variables?

1232

What are the operations that support avoiding duplicate record?

1492

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