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 primary usages of datastage tool?

1075

How many areas for files does datastage have?

1153

What are constraints and derivations?

1170

What are the types of containers and how to create them?

976

What are the benefits of datastage?

1238

What are the different layers in the information server architecture?

1124

What are the functionalities of link partitioner and link collector?

1009

How do you reject records in a transformer?

1124

How many types of stage?

1179

what is ds administrator used for?

1170

What are transforms and what is the differenece between routines and transforms?

1066

What is the difference between round-robin partitioning and hash partitioning?

973

What is fact? What are the types of facts?

1117

What is staging area referring to?

1129

How etl testing is different from database testing?

1047

Un-Answered Questions { Data Warehouse }

What is hybrid slowly changing dimension?

1036

What are the different clients of powercenter?

1060

what are the all possible features supported modify stage?

2137

What is the meaning of decode in informatica?

1122

What are the different uses of a repository manager?

1100

What are the types of schemas we have in data warehouse and what are the difference between them?

941

How can bottlenecks be identified?

1018

Explain absolute filter?

972

what are slowly changing dimensions? Why we are used scd?

1125

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1921

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1013

What is workflow manager?

1047

How is character variable converted into numeric variable and vice versa?

1177

What is cognos connection?

1297

Explain what are slowly changing dimensions?

1024

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