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 7311

whats difference between ls -ltr and ls -lrt?

L&T,

5 40734

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

L&T,

1 5554

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 10189

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 9183

whats relation between configuration file and datasets?

L&T, Wipro,

2 11341

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 14084

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

4 12735

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

TCS,

2071

Which version configuration tool used in ur project?

CTS, TCS,

3276

how you will maintain version?

CTS, TCS,

3 9328

what are 3 tech challenges/ common issues you face?

TCS,

2354

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

IMB, TCS,

2311

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

2 8031

WHAT IS SAP BO AND BO?

1 7057

Un-Answered Questions { Data Warehouse }

What is latest version of power center / power mart?

1066

Explain load alternative records / rows into multiple targets - informatica

1169

Give some difference between oltp and olap.

1019

What is an Integration service in Informatica?

1146

What commands are used in the case of including or excluding any specific variables in the data set?

1108

What is the function of model design accelerator?

969

How to create a cube in Transformer? What is the process? Please mention process thank u

1777

what is the project environment(for each project the environment is same or different to different project)?

2235

expain about the tune parameters?

2425

What are the components of report net?

1291

What is informatica? Why do we need it?

1120

what are the filters in framework manager and report studio?

1005

How can I run the 2 gui merge files?

1199

What all are steps in up gradation of Informatica server?

1056

Can you explain surrogate key?

1059

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