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

How to generate sequence numbers using expression transformation?

Informatica,

1089

What is Index Caches size?

Informatica,

1115

What is Session and Batches?

Informatica,

1108

Explian the connected and unconnected lookup transformation

Informatica,

1 1515

What is the Rank index port in Rank transformation?

Informatica,

1061

What are mapplets? How is it different from a Reusable Transformation?

Informatica,

1090

I have a flat file, want to reverse the contents of the flat file

Informatica,

1127

which one is better performance wise joiner or look up

Informatica,

1093

write a query to retrieve the latest records from the table sorted by version(scd)

Informatica,

1068

How many types of sessions are there in informatica.please explain them?

Informatica,

1166

Which transformation is needed while using the Cobol sources as source definitions?

Informatica,

1174

What is an unconnected transformation?

Informatica,

1087

What is the status code in stored procedure transformation?

Informatica,

1182

Explain dynamic target flat file name generation in informatica

Informatica,

1055

update strategy transformation in informatica

Informatica,

1064

Un-Answered Questions { Data Warehouse }

Difference between Data and Index Caches?

1137

Describe the set operators in teradata.

1005

What are mapplets?

1271

What is the size of database for you project?

1597

What is an active transformation?

1110

What is informatica? Why do we need it?

1097

How do you handle two sessions in Informatica

1164

What is microstrategy intelligence server?

1035

how does sas handle missing values in functions? : Sas programming

1213

How many universes can be created in a project?

1048

What are the three tiers in etl?

1113

Differentiate between data file and descriptor file?

1059

what is hierarchy flattening? : Sas-di

1081

Describe primary index in teradata?

1000

Explain hybrid slowly changing dimension?

1006

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