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?

1017

Can there be sub steps of etl steps?

1107

What are the etl testing operations includes?

1158

What are the various tools used in etl?

1114

What is partitioning? Explain different types of partitioning?

1330

What do you understand by active and passive transformations?

983

What are the names of the layers in etl?

1047

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

1154

how many steps are there in etl process?

1032

What is meant by incremental load?

1163

Compare etl & elt?

1060

What dedup-component and replicate component does?

1327

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

1457

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

1496

What is a look-up?

1356

Un-Answered Questions { Data Warehouse }

What is the difference between validated and compiled in the datastage?

1378

Mention the category in which sas informats are placed?

1084

What subtotaling features does microstrategy desktop contain?

1051

Explain is fact table?

980

How to call shell scripts from informatica?

1045

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3296

how do u set partition points in the mapping?

2303

What is the effect of dls on microstrategy?

1061

What is ods (operation data source)?

1063

What is a data profile?

1027

What is Redshift Spectrum?

Can you brief about the Data warehouse project you worked on?

2443

Explain difference between view and materialized view?

1023

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4462

In informatica workflow manager, how many repositories can be created?

1441

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