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?

1056

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

1135

How will you solve the problem that occurs during update?

1111

What is a dimension table?

1104

What are tpump utility limitations?

1180

How do you verify a complicated sql?

1117

How to eliminate product joins in a teradata sql query?

1090

How do you determine the number of sessions?

1109

How do you set the session mode parameters in bteq?

1144

Is multi insert ansi standard?

2257

How does hashing happens in teradata?

1150

What's the syntax of sub string?

1 2676

How many types of index are present in teradata?

1 1909

How to select first n records in teradata?

1168

What is a level of granularity of a fact table?

1225

Un-Answered Questions { Data Warehouse }

Approximately what date is represented by the SAS date value of 730?

1277

Can you define bitmap index?

1134

What are the uses of sas?

1366

how to connect to a flatfile through ftp in informatica

14395

Explain etl mapping sheets?

1131

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2328

What are the special input delimiters used in SAS?

1246

How scientific data processing is different from commercial data processing?

1138

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

1046

What do you mean incremental aggregation?

1131

Have you created hierarchy in obiee. If so where and how?

923

What are the various transformation available?

1065

What is informatica? Why do we need it?

1166

What do you know about partition and also tell us about partition components in abinitio?

1108

server hot-ws270 is connect to Repository B. What does it mean?

2659

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