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

how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?

Cambridge, Patni,

3 12836

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

Accenture,

1 5818

how get the grand total in master-detail report?

Patni,

1 2308

what is a force compile

Cap Gemini, IBM,

2 9290

what is a message handler

IBM,

3 11044

what is the use of invokation id

IBM,

2 11134

what is a nodemap constraint

IBM,

2 13529

how can we load starting with 11th record of a table from source to target

IBM,

6 11059

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

IBM,

2 6962

can we load the data with out a primary key of a table? what is target plan?

IBM,

6 15455

what is normalizer transformation?

Wipro,

4 8176

What is proc sql pass through facility?

L&T,

4 9984

how eliminate the duplicates in flat file with out using sorter ,aggregater

Wipro,

4 11507

how to load dimension table and fact table. plz tell me the steps.

Cognizant, IBM,

1 2162

how to load the data to fact table?

1 2788

Un-Answered Questions { Data Warehouse }

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2093

what are the data modeling tools you have used?(polaris)

2058

explain in detail about type 3?

1084

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

1196

Explain how to generate iqd file from framework manager?

1022

Explain about a tricky situation for which you found a very simple solution?

1077

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

1044

Hi friends, what are the new features in abinito3.0?

2860

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2824

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

What is the purpose of Dataware Control?

1121

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

1222

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

1233

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)

2794

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

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