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?

1235

When tpump is used instead of multiload?

1146

What are the various etl tools in the market?

1126

How to find duplicates in a table?

1282

What is basic teradata query language?

1164

Steps to create a data model?

1184

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

1235

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

1246

Syntax for case when statement?

1118

Difference between star and snowflake schemas?

1253

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?

1155

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

1244

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

1032

How do you see a ddl for an existing table?

1063

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

1155

Un-Answered Questions { Data Warehouse }

What is a level of granularity of a fact table?

1225

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2004

What is a compound attribute in microstrategy?

1092

What do you mean by teradata intelliflex?

1171

Explain Association algorithm in Data mining?

2354

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1139

is cognos 7 is better than cognos 8

2213

At which levels you can set the vldb properties? Which level has the highest pecedence?

992

Explain how are the dimension tables designed?

1118

What are the various tools used in etl?

1114

What is the purpose of having stored procedures in a database?

1225

How to do Performence Tunning in Cognos Reports?

2533

Why denormalization is promoted in universe designing?

1032

Differentiate between validated and Compiled in the Datastage?

1359

What is the way to execute pl/sql script using informatica mapping?

1685

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