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

list out all the transformations which use cache?

1 1253

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

Informatica,

1 1178

What are multi-group transformations?

Informatica,

1 1188

Design a mapping to load a target table with the following values from the above source?

Informatica,

1 1415

How to load last n records of file into target table - informatica

Informatica,

1 1153

What is the commit type if you have a transaction control transformation in the mapping?

Informatica,

1 1109

How can we improve session performance in aggregator transformation?

Informatica,

1 1188

Explain direct and indirect flat file loading (source file type) - informatica

Informatica,

1 1372

What are the basic requirements to join two sources in a source qualifier transformation using default join?

Informatica,

1 1236

What is Data Caches size?

Informatica,

1 1144

How do you promote a non-reusable transformation to reusable transformation?

Informatica,

1 1194

Explain load alternative records / rows into multiple targets - informatica

Informatica,

1 1234

Explain lookup transformation in informatica

Informatica,

1 1143

How many ways a relational source definition can be updated and what are they?

Informatica,

1 1092

What are the differences between joiner transformation and source qualifier transformation?

Informatica,

1 1249

Un-Answered Questions { Data Warehouse }

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2060

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Write the unconnected lookup syntax?

1146

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1176

What is a rollup component? Explain about it.

1241

What is the purpose of Dataware Control?

1119

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

What is the difference between business requirement document and use case document.

1080

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

What is aggregate table and aggregate fact table ... Any examples of both?

1118

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2824

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1239

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