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

How can you track login parameters of users in teradata?

1198

When tpump is used instead of multiload?

1106

What are the various etl tools in the market?

1074

How to find duplicates in a table?

1219

What is basic teradata query language?

1118

Steps to create a data model?

1140

Can you fastexport a field, which is primary key by putting equality on that key?

1180

While creating table my dba has fallback or no fallback in his ddl. What is that?

1187

Syntax for case when statement?

1069

Difference between star and snowflake schemas?

1157

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1114

What is the difference between global temporary tables and volatile temporary tables?

1183

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

989

How do you see a ddl for an existing table?

1018

How many codd's rules are satisfied by teradata database?

1113

Un-Answered Questions { Data Warehouse }

Why is business intelligence (bi) important in data warehousing?

947

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

983

Can you define cognos powerplay?

1095

Describe the ways in which you can create a macro variable?

1085

What do you know about sas data set?

1122

How does microstrategy object manager determine if two objects in different projects are the same?

1070

State the difference between an operational datastage and a data warehouse?

1134

Tell me about MD5 functions in informatica

929

What is the function of model design accelerator?

959

Sequence generator, when you move from develoment to production how will you reset

2043

What are all types of Batches?

1029

How to update source definition?

1094

Explain what is full load & incremental or refresh load?

990

What are the key features of chameleon that separates it from other algorithms?

1121

What is spool space?

1161

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