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

What is tracing level and what are the types?

958

Can there be sub steps of etl steps?

1028

What are the etl testing operations includes?

1109

What are the various tools used in etl?

1043

What is partitioning? Explain different types of partitioning?

1240

What do you understand by active and passive transformations?

938

What are the names of the layers in etl?

1001

What are the different etl testing categories as per their function?

1076

how many steps are there in etl process?

979

What is meant by incremental load?

1094

Compare etl & elt?

1012

What dedup-component and replicate component does?

1273

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

1362

What is the role of co-operating system in abinitio?

1446

What is a look-up?

1253

Un-Answered Questions { Data Warehouse }

What is the difference between datastage and informatica?

1118

What is critical column?

1181

What are all the different types of prompt in cognos?

1051

What is the difference between datawarehouse and bi?

955

How to sort in descending order?

1257

define the logic behind the sparsity in cubes?

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

What are cognos connection initial page components?

1140

Explain fact table?

1050

What is the use of powerhouse?

1077

What are the differences between datastage and informatica?

1177

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2460

What is a passive transformation?

1103

What is meant by a Clique?

1063

Define data aggregation?

1094

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