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 do you pass parameters in a script?

L&T,

1 7423

whats difference between ls -ltr and ls -lrt?

L&T,

5 41027

why do we need a datawarehouse when we have databases to store data?

L&T,

1 5647

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

L&T,

4 10433

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

L&T,

2 9317

whats relation between configuration file and datasets?

L&T, Wipro,

2 11476

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 14300

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 12914

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

TCS,

1 2129

Which version configuration tool used in ur project?

CTS, TCS,

1 3347

how you will maintain version?

CTS, TCS,

3 9516

what are 3 tech challenges/ common issues you face?

TCS,

1 2414

have u done any performance tuning? how u ll do?

IMB, TCS,

1 2388

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 8150

WHAT IS SAP BO AND BO?

1 7151

Un-Answered Questions { Data Warehouse }

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8288

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2497

What is the difference between business requirement document and use case document.

1088

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3447

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1214

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2215

What is dimensional table?

1168

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2346

What is the purpose of Dataware Control?

1121

Are you involved in writing the inferential analysis plan? Tables specifications?

4022

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2304

What r the names of the reports that you prepared?

1032

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