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?

1176

Differentiate primary key and partition key?

986

What is a clique?

1103

What are the 5 phases in a multiload utility?

1037

Which is faster fastload or multiload?

1121

What is the opening step in basic teradata query script?

1044

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

1057

What is oltp?

983

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

1111

How to Extract data from multiple legacy systems?

1128

What is collect statistics?

1006

Differentiate database data and data warehouse data?

1123

What does sleep function does in fast load?

1144

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

1181

Difference between multiload and tpump?

1118

Un-Answered Questions { Data Warehouse }

How to partition the Session?

1117

Describe the ways in which you can create macro variables? : sas-macro

1069

What is the difference between low affinity and high affinity connections?

1023

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2499

Explain about cumulative Sum or moving sum?

1046

How can you import tables from a database?

1092

What are the different types of reports present in cognos?

988

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2026

What are the methodologies of data warehousing?

993

Name the different type of processing based on the steps that you know about?

1070

Explain the informatica workflow?

1075

What are the differences between datastage and informatica?

1180

can metadata be manually edited? If yes, how?

1034

where to store informatica rejected data?

1100

Mention a few design and development best practices for informatica?

1002

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