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

How we can create indexes after completing the load process?

1160

What is the surrogate key?

1261

Why is sorter an active transformation?

1129

Define sessions in informatica etl?

1034

Define filter transformation?

1097

What is meant by a domain?

1127

What is the benefit of partitioning a session?

1182

Explain the difference between mapping parameter and mapping variable?

1039

What are the various types of transformation?

1179

Write the prerequisite tasks to achieve the session partition?

1158

What is the reusable transformation?

1047

What is meant by active and passive transformation?

1125

What is the difference between a repository server and a powerhouse?

1513

Define mapplet?

1009

Explain the scenario which compels informatica server to reject files?

1168

Un-Answered Questions { Data Warehouse }

Why are meta service important then other services?

974

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

What is confirmed fact in dataware housing?

6968

What is the difference between input and infile statement?

1175

How to create Index to the table in the universe designer and how it improves the Query performence

2553

Explain the Roles in mstr?

978

Which query language is used by amazon redshift?

How do you start developing a datastage project?

1105

Compare ETL & Manual development?

950

What is amazon redshift?

How would you define the end of a macro?

1095

Mention some types of transformation?

1048

How do you update the records with or without using update strategy?

1116

What are the different versions of informatica?

1275

Explain what are the vaious etl tools in the market?

943

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