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 model and say about process how to create model and how to test model?

IBM,

1 1118

how you provide security to reports? How you provide security to packages ?

IBM,

1 1131

how to perform single sign in cognos by using url?

IBM,

1 1224

what is the difference between list report and crosstab report?

IBM,

1 1250

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

IBM,

1 1096

what are the special features in cognos reportnet?

IBM,

1 1117

what is log in cognos?

IBM,

1 1286

how you migrate reports to cognos 8 from previous versions?

IBM,

1 1113

what are slowly changing dimensions? Why we are used scd?

IBM,

1 1203

how to create cubes in transformer ?

IBM,

1 1136

what are the names of the reports that you prepared?

IBM,

1192

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

IBM,

1 1136

how can I test reports in cagnos?

IBM,

1 1234

how to create measures and dimensions?

IBM,

1 1194

explain how to create powerplay reports?

IBM,

1 1081

Un-Answered Questions { Data Warehouse }

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1667

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

2342

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..

2765

Write the unconnected lookup syntax?

1145

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

1172

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

4796

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...................................

2332

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!!!

2257

What is aggregate table and aggregate fact table ... Any examples of both?

1118

Explain about a time when you discovered a more efficient way to do a work task?

1222

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Are you involved in writing the inferential analysis plan? Tables specifications?

4018

Have you have ever worked in unix environment and why it is useful in datastage?

1213

Explain how to generate iqd file from framework manager?

1020

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

2303

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