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?

906

Can there be sub steps of etl steps?

959

What are the etl testing operations includes?

1053

What are the various tools used in etl?

987

What is partitioning? Explain different types of partitioning?

1170

What do you understand by active and passive transformations?

893

What are the names of the layers in etl?

950

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

1017

how many steps are there in etl process?

929

What is meant by incremental load?

1026

Compare etl & elt?

955

What dedup-component and replicate component does?

1232

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

1315

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

1394

What is a look-up?

1141

Un-Answered Questions { Data Warehouse }

How a routine is called in datastage job?

1051

What are the difference between snow flake and star schema?

956

How to limit decimal places for variable using proc means?

1056

Define meta stage?

1154

Describe the between keyword in teradata?

991

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2209

what is size of u r database?

2262

What is prompt types of prompts?use of prompts syntax of prompt?

1244

What are the data types that sas contain?

1128

What is the difference between Active and Passive transformation?

1096

What are SAS/ACCESS and SAS/CONNECT?

1092

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1068

Explain what is the difference between business requirement document and use case document.

980

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1026

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1181

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