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 5700

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 7894

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 10257

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

ACC,

5 6710

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

2 6223

Difference Between Scan and Substr

2 17554

what is _error_?

Axis Bank, Cognizant, JPMorgan Chase,

2 10568

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 11794

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 9403

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 8498

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

1 2109

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 18417

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 11611

how to find unique records in informatica level

IBM,

1 3750

what is the difference between DUPKEY and NODUPKEY???

Cognizant, EXL,

4 23688

Un-Answered Questions { Data Warehouse }

Explain in detail about scd type 1 through mapping.

1648

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

1202

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1854

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1200

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

1086

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4797

explain in detail about type 3?

1093

How would you format some text using css to be verdana and bold?

1150

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153

What is the purpose of Dataware Control?

1121

What is rollup component?

1343

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

Write the unconnected lookup syntax and how to return more than one column.

1176

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

2310

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

2346

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