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?

1024

How many areas for files does datastage have?

1090

What are constraints and derivations?

1123

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

942

What are the benefits of datastage?

1191

What are the different layers in the information server architecture?

1084

What are the functionalities of link partitioner and link collector?

957

How do you reject records in a transformer?

1065

How many types of stage?

1139

what is ds administrator used for?

1120

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

1014

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

926

What is fact? What are the types of facts?

1021

What is staging area referring to?

1060

How etl testing is different from database testing?

975

Un-Answered Questions { Data Warehouse }

What is a sorter transformation?

1055

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

884

Explain bus schema?

901

Explain what are the tasks that loadmanger process will do?

871

What does refresh system mean, and what are its distinctive choice?

1092

Describe link sort?

969

explain html document?

959

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2477

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7094

What are all the types of indexes in Cognos?

1158

What is the meaning of Caching in Teradata?

1092

Differentiate between sas functions and sas procedures.

1159

Explain the parallel data extension in teradata?

1037

How do you load only null records into target?

1154

How create measures and dimensions?

1011

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