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

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

1195

Explain what is de-partition in abinitio?

1360

Mention what information does a .dbc file extension provides to connect to the database?

1353

Mention what are the different types of parallelism used in abinitio?

1131

Explain what is sort component in abinitio?

1115

Explain what does dependency analysis mean in abinitio?

1160

Mention what is the syntax for m_dump in abinitio?

1492

Mention how can you connect eme to abinitio server?

1 3875

Explain what is the architecture of abinitio?

1227

Mention what is rollup component?

1144

Mention what the difference between “look-up” file and “look is up” in abinitio?

1323

Pdl with an example?

1118

Mention what dedup-component and replicate component does?

1057

Mention what is the role of co-operating system in abinitio?

1 2114

Explain what is sandbox?

1103

Un-Answered Questions { Data Warehouse }

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1986

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5697

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1046

What are the different kinds of views available in a datastage director?

1042

Under which circumstances, informatica server creates reject files?

1109

What is embedded metric?

1005

What is metadata in microstrategy?

1128

Explain fastload in teradata?

1120

How is union transformation utilized?

1022

What is node? How many nodes and amps used in your previous project?

1121

What is the SAS data set?

1148

How do you reject records in a transformer?

1136

design of staging area?

2040

Syntax for case when statement?

1076

Explain scan md?

1089

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