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 7400

whats difference between ls -ltr and ls -lrt?

L&T,

5 40964

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

L&T,

1 5619

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 10393

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 9293

whats relation between configuration file and datasets?

L&T, Wipro,

2 11445

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 14251

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

4 12868

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

TCS,

1 2116

Which version configuration tool used in ur project?

CTS, TCS,

1 3331

how you will maintain version?

CTS, TCS,

3 9467

what are 3 tech challenges/ common issues you face?

TCS,

1 2399

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

IMB, TCS,

1 2370

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

2 8129

WHAT IS SAP BO AND BO?

1 7135

Un-Answered Questions { Data Warehouse }

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

1210

what is document design in boxi,have u participate in that

2289

Demonstrate experience in maintaining quality process standards?

2658

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1189

What are the data types present in bo? What happens if we implement view in the designer and report?

1076

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

1769

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

How to create the source and target database connections in server manager?

1139

Hi, If anyone has base SAS certification dumps, please share.

1932

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2088

Explain in detail about scd type 1 through mapping.

1641

What is dimensional table? Explain the different dimensions.

1262

How to add default rules in transformer?

1277

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

2201

what are the names of the reports that you prepared?

1185

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