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?

1205

What is the surrogate key?

1368

Why is sorter an active transformation?

1198

Define sessions in informatica etl?

1106

Define filter transformation?

1151

What is meant by a domain?

1189

What is the benefit of partitioning a session?

1240

Explain the difference between mapping parameter and mapping variable?

1085

What are the various types of transformation?

1247

Write the prerequisite tasks to achieve the session partition?

1234

What is the reusable transformation?

1105

What is meant by active and passive transformation?

1195

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

1581

Define mapplet?

1061

Explain the scenario which compels informatica server to reject files?

1213

Un-Answered Questions { Data Warehouse }

What is abap? What are idocs?

1023

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

1015

What is difference between query studio and report studio?

1157

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2453

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2278

What exactly do you know about catching in teradata?

1082

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2188

What are the informatica performance improvement tips

1152

How do you load first and last records into target table?

1215

Define mapping and session?

1093

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2026

 Informatica Checkpoints

3380

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3548

How do you reject records in a transformer?

1181

------------------What is Inline Query?

2261

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