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?

1243

Explain what is de-partition in abinitio?

1415

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

1426

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

1175

Explain what is sort component in abinitio?

1159

Explain what does dependency analysis mean in abinitio?

1218

Mention what is the syntax for m_dump in abinitio?

1524

Mention how can you connect eme to abinitio server?

1 4180

Explain what is the architecture of abinitio?

1275

Mention what is rollup component?

1187

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

1372

Pdl with an example?

1165

Mention what dedup-component and replicate component does?

1089

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

1 2188

Explain what is sandbox?

1150

Un-Answered Questions { Data Warehouse }

What is conduct>it?

1177

What is the function you would use to transfer a string into a decimal?

1290

Can you define pivot?

1221

What are the different layers in the information server architecture?

1182

How do you do backup and recovery in teradata?

1091

Explain what is the difference between microstrategy and cognos reporting tool?

1156

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1121

What is the primary index in teradata?

1295

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1291

What is write-back in obiee ?

894

How can I remove header from output data set?

2670

Explain data step in SAS

1163

Different sorts of metadata that stores in the storage facility?

1083

What are different types of transformations available in informatica?

1064

explain the difference between proc means and proc summary?

1184

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