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 the functional & architectural differences between business objects and web intelligence reports?

1 2475

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1 1115

Explain about a task that really tested your analytical abilities?

1 1325

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1 1234

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1 1124

Explain the data types present in bo and what happens if we implement view in the designer and report?

1 1089

Explain is data mart?

1 1087

Explain what task is 98% of the required work of a business analyst?

1 1205

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1 1058

Difference between b.o 5.1 and 6.1b?

1 1368

What is the difference between absolute and relative div positioning?

1 1110

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1 1075

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

1 1024

What is the working process for application.cfm?

1 1103

Is there any rownum object from which we can do this?

1 1008

Un-Answered Questions { Data Warehouse }

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

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

1176

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

6075

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

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

2060

faq's on cognos

4112

EXL informatica Questions

1460

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

8284

Explain scd type 3 through mapping.

1071

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

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

2207

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492

What is dimensional table? Explain the different dimensions.

1267

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

1082

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