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 18265

What are the Differences between connected and unconnected lookup?

TCS,

6 21180

what is meant by lookup caches?

Cap Gemini, Informatica,

2 11171

What are the types of lookup caches?

Accenture, IBM, Informatica,

10 69100

What are the Differences between static cache and dynamic cache?

1 8022

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

DELL, IBM, Lehman Brothers,

4 13572

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

Informatica,

1 18732

What are the rank caches?

Informatica,

2 11778

What is the Rankindex in Ranktransformation?

7 21105

What is the Router transformation?

Informatica,

2 10470

What are the types of groups in Router transformation?

Informatica,

1 10426

Why we use stored procedure transformation?

4 11594

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

Informatica,

1 7396

What is the status code?

1 8960

What is source qualifier transformation?

1 5203

Un-Answered Questions { Data Warehouse }

What needs to be done while starting the database?

1115

Explain what are the measure objects?

997

What is data type of the surrogate key?

1004

How do you test for missing values?

1643

How does proc sql work?

1101

tell me two or three issues from client side and how to solve those issues?

2171

What are the different lookup cache(s)?

1123

how can you import .csv file in to sas? : Sas programming

1104

what is a worklet?

999

What is the use of tabular model, tabular sql, tabular reference in real time application?

968

Explain what are the advantages data mining over traditional approaches?

1165

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2199

What are the uses of client software involved in teradata?

985

Your i-sever crashed. What will you do?

1072

Can you explain the process of calendar?

1116

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