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?

1195

When tpump is used instead of multiload?

1105

What are the various etl tools in the market?

1073

How to find duplicates in a table?

1218

What is basic teradata query language?

1113

Steps to create a data model?

1133

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

1178

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

1186

Syntax for case when statement?

1064

Difference between star and snowflake schemas?

1152

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?

1113

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

1182

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

986

How do you see a ddl for an existing table?

1018

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

1112

Un-Answered Questions { Data Warehouse }

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

992

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1099

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

1059

Explain pmcmd command usage in informatica

1132

Do you find any difficulty while working with flat files as source and target?

1098

how many types of prompts are there? : Sas-bi

1081

What are the default statistics for means procedure?

1245

What specific features and functionality do I get with olap services?

953

What is called materialized view?

1076

What is local and formal parameter?

1402

How do you define Teradata?

1035

Why update strategy and union transformations are active? Explain with examples.

1240

what is the difference steps for data modeling?

2139

Give some information on report bursting?

993

Name types of category in which SAS Informats are placed?

1151

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