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 are the differences between datastage and informatica?

1177

Explain the importance of surrogate key in data warehousing?

1190

How to implement complex jobs in data stage?

1112

Difference between server jobs & parallel jobs?

1077

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1279

What are the functionalities of link collector?

1085

What is the purpose of pivot stage?

1168

When do we analyze the tables?

968

What is full load & incremental or refresh load?

1203

What is tracing level?

1068

what is a worklet?

994

When do we analyze the tables? How do we do it?

960

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

976

What is etl process? How many steps etl contains?

1034

How many steps etl contains?

944

Un-Answered Questions { Data Warehouse }

What is a relationship?

990

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1829

Explain batch processing in ab initio?

1456

Why fact table is in a normal form?

991

What is primary and backup node?

1127

What is the difference between regular dimension and derminant?

2275

What is difference between e-r modeling and dimensional modeling?

924

What is dimensional table?

1063

what are validation tools that are used in sas? : Sas-administrator

1058

What are the different types of security you have worked in obiee?

789

What is the function of output statement in a SAS Program?

1074

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

Reusable transformation and shortcut differences

1840

What is the function of cognos dispatcher?

1214

what r the job openings SAS for fresher graduates !

2457

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