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

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

Axtria,

1 5609

Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me

3 7718

why consolidation and custom group not used in ic cubes. and then i will over come by derived element.. what my question is ...even (consolidation and custom group) also derived element,why we are not used. Can any body give the assistant for this issues... Regards, sekhar

Cognizant,

1 10126

Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?

ACC,

5 6471

What is informatica? What exactly are the practical uses in real world

2 6082

Difference Between Scan and Substr

2 17329

what is _error_?

Axis Bank, Cognizant, JPMorgan Chase,

2 10461

Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you

3 11607

Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you

1 9281

EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer

Accenture,

3 8339

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2032

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

Cognizant, Cognos,

7 18046

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

IBM,

4 11406

how to find unique records in informatica level

IBM,

1 3674

what is the difference between DUPKEY and NODUPKEY???

Cognizant, EXL,

4 23441

Un-Answered Questions { Data Warehouse }

What is a full backup?

975

What subtotaling features does microstrategy desktop contain?

998

What is vdl (view definition language) explain?

1054

what is an ETL or ETT? And what are the different types?

7503

what are the functions required to be called for enabling or disabling the bulk load of mode?

How can you set the session management?

1131

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1072

How to run a graph infinitely?

1130

Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

1135

How can you generate reports in informatica?

1040

Code check-in and check-out commands in AbInitio

4321

Explain about Informatica server process that how it works relates to mapping variables?

1091

What is rank transformation in informatica

1185

What can be achieved by using the teradata rdbms?

1047

what is sas data set?

1110

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