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 the scenarios in which full table scans occurs?

1011

Which is more efficient group by or distinct to find duplicates?

1092

How will you solve the problem that occurs during update?

1059

What is a dimension table?

1072

What are tpump utility limitations?

1129

How do you verify a complicated sql?

1071

How to eliminate product joins in a teradata sql query?

1039

How do you determine the number of sessions?

1064

How do you set the session mode parameters in bteq?

1110

Is multi insert ansi standard?

2214

How does hashing happens in teradata?

1096

What's the syntax of sub string?

1 2593

How many types of index are present in teradata?

1 1815

How to select first n records in teradata?

1110

What is a level of granularity of a fact table?

1158

Un-Answered Questions { Data Warehouse }

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1207

Explain the versions of reportnet?

990

To import the flat file definition into the designer where should the flat file be placed?

1061

how many steps are there in etl process?

982

Why is data processing considered beneficial?

1068

explain about citrix scheduling tool in datastage

2462

Explain what are the different versions of informatica?

1102

how do you debug and test your sas programs? : Sas programming

1132

What are the differences between star and snowflake schema?

1110

Explain what is analytical or analytic mean?

1021

According to his methodology what all you need before you build a datawarehouse

1761

What do you mean by staging area?

976

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

What is a node in Informatica?

1046

How would you load a very large file in teradata in general?

1034

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