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 many types of keys are there i.e primary key and foreign key etc..?

IBM,

3 7018

what are summary filters? grouped filters?

IBM,

3 7271

How will you display "Mr" for male & "Mrs" for female in target table?

7 12938

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 8914

How will you combine 3 different sources with a single source?

3 8642

how will you get 21 to 30 record from 50 records?

6 11756

how will you remove the duplicate records from flat file without using sorter?

7 18737

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 9206

Without source how to insert record to target?

6 19788

How to jion 2 tables, without using any condition?

Amazon,

11 37695

How to compare Source and Target table, without using dynamic lookup?

4 11069

In joiner, how to load Master table in Target?

2 7886

Without using Lookup & Sequence Generator, How to generate Sequence?

CTS,

5 14133

Is it possible to have "5 source & 5 Target" in single mapping?

1 6474

How to update records in Target, without using Update Strategy?

3 12008

Un-Answered Questions { Data Warehouse }

Explain scd type 3 through mapping.

1008

What is the difference between informatica and datastage?

1229

what is Active lock explain

2799

What sort of existing documents should business analysts refer to when starting on a new project?

1010

What is level metrics in microstrategy?

1031

What is the profile and package?

2299

Can a record be inserted and updated in database using microstartegy?

932

What are objects?

1018

What is the benefit of partitioning a session?

1182

What is the general format of function in sas? : sas-grid-administration

975

Why is auto-regression used in forecasting used on cognos platform?

1021

How can we schedule the graph in unix?

1000

In development project what is the process to follow for an etl developer from day1

1724

What do you understand by active and passive transformations?

942

How can we store previous session logs?

1083

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