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 types of lookup?

Wipro,

3 18392

What are the Differences between connected and unconnected lookup?

TCS,

6 21407

what is meant by lookup caches?

Cap Gemini, Informatica,

2 11268

What are the types of lookup caches?

Accenture, IBM, Informatica,

10 69464

What are the Differences between static cache and dynamic cache?

1 8086

Which transformation should we use to normalize the COBOL and relational sources?

DELL, IBM, Lehman Brothers,

4 13765

How the informatica server sorts the string values in Rank transformation?

Informatica,

1 18827

What are the rank caches?

Informatica,

2 11899

What is the Rankindex in Ranktransformation?

7 21345

What is the Router transformation?

Informatica,

2 10588

What are the types of groups in Router transformation?

Informatica,

1 10493

Why we use stored procedure transformation?

4 11739

What are the types of data that passes between informatica server and stored procedure?

Informatica,

1 7480

What is the status code?

1 9056

What is source qualifier transformation?

1 5298

Un-Answered Questions { Data Warehouse }

What is target designer and target load order?

1172

Explain the characteristics of cognos?

1090

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

Write some methods to apply securities in framework manager model?

1172

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3409

how to delete one row in target dataset

3166

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

830

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2065

What is many-to-many dimensional model in datawarehousing ?

992

what is 'reconsideration error' and how can i respond to this error and how to debug this

2675

it will become easy if uuu provide website linkssss and list of consultanciessssss

2030

Have you have ever worked in unix environment and why it is useful in datastage?

1194

Which development components of informatica have the highest usage?

1104

how does rules tracer help us?

What is the difference between passive stage and active stage?

1650

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