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 differences between teradata and ansi session modes in teradata?

1223

Differentiate primary key and partition key?

1038

What is a clique?

1163

What are the 5 phases in a multiload utility?

1090

Which is faster fastload or multiload?

1185

What is the opening step in basic teradata query script?

1095

What are types of partition primary index (ppi) in teradata?

1109

What is oltp?

1018

What is node? How many nodes and amps used in your previous project?

1159

How to Extract data from multiple legacy systems?

1176

What is collect statistics?

1055

Differentiate database data and data warehouse data?

1166

What does sleep function does in fast load?

1213

What is the command in bteq to check for session settings ?

1240

Difference between multiload and tpump?

1167

Un-Answered Questions { Data Warehouse }

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

1056

What is the sortmerge collector?

1178

Explain translate function?

1265

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11857

Can we use target hash file as a lookup ?

3381

Explain what are components of reportnet?

1032

what are the session parameters? How do u set them?

2094

How does microstrategy object manager determine if two projects are related?

1114

is there any difference between operational database and data base?if yes what r they?

2121

Explain the main difference between the sas procedures and functions? : Sas-administrator

1117

Is it possible to revert a global repository to local one and why?

1143

How do we call shell scripts from informatica?

1193

how to connect to a flatfile through ftp in informatica

14395

Can any one explain the hierarchies level data warehousing.

1044

What is incremental aggregation?

1139

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