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

Whether dimension table can have numeric value?

1149

Have you have ever worked in unix environment and why it is useful in datastage?

1133

Differentiate between hash file and sequential file?

1072

Define project in datastage?

1093

How to clean the datastage repository?

1127

How rejected rows are managed in datastage?

1522

Does datastage support slowly changing dimensions ?

1105

How many types of hash files are there?

1185

Nls stands for what in datastage?

1190

Define meta stage?

1203

Define orabulk and bcp stages?

1122

Define repository tables in datastage?

1158

How complex jobs are implemented in datstage to improve performance?

1042

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

How a routine is called in datastage job?

1109

Un-Answered Questions { Data Warehouse }

what is the custome stage in datastage? how can we impliment that one? plz tell me

2367

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3024

How do you schedule or monitoring the job?

1210

what is the complex transformation you used in informatica

2587

How can you create a macro variable with in data step? : sas-macro

1043

what is sas metadata server? : Sas-di

1107

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

What are some examples of informatica etl programs?

943

Can you explain new content durability?

1029

What do you mean by a transaction file and how it is different from that of a sort file?

1048

Tell me more about the parameters in macro? : sas-macro

1053

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2091

What are the five ways to do a table lookup in sas? : sas-grid-administration

1064

Difference between informat and format?

1094

What is cluster AWS cloud?

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