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

what is bobble chart?

Syntel,

1 5996

how can you get the errors in job? when loops are araised we get error?

Syntel,

1 2171

what is stitch query?

Syntel,

2 8887

what is materialised view? why we use it in data warehousing?

HCL,

5 10719

what is view? types of views?

HCL,

3 8207

what is online view?

HCL,

1 1999

how can you create a report like if country=india then true if contry=spain then false?

Syntel,

2 6195

what is your project workflow and your role in the project?

Syntel,

5 11863

difference between stored procedure and function?

Syntel,

4 9348

how many types of formats you can run a report using cognos?

HCL,

4 10356

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

HCL,

1 5051

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

HCL,

1 2149

what does my folder and public folder contains? difference between the my folder and public folder?

HCL,

3 9713

what is a join? what are the types of joins?

HCL, Satyam,

5 10487

what is an outer join? difference between left outer join right outer join with an example?

HCL,

1 11145

Un-Answered Questions { Data Warehouse }

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

1026

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

EXL informatica Questions

1451

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

2138

how many reports have u created ? explain a few.

2152

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

1073

What is node? How many nodes and amps used in your previous project?

1167

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

8274

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

2338

How do you remove duplicate records in informatica? And how many ways are there to do it?

1224

how to generate the test data in sas without input data? : Sas-administrator

1194

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

1189

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2298

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1168

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

1839

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