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

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 14987

how to identify new and old values in source qualifier or any other transformations using informatica

2 6218

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 28027

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 4759

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

Wipro,

3 7346

How to do performance tunning of reports?

1 2376

Where do we use ACvisitor class?

1 2573

What property you use to Hide a control at runtime?

2 5844

How do you design a report which has multiple child datastream (horizontal seq)

1 2674

How do we have left -right flow , normally its top-down flow

1 6195

How can you change the group key dynamically?

L&T,

1 4618

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

Mphasis,

2 6921

How to fix the order of Prompts? How to assign the default value in prompt?

Mind Tree,

2 8002

What is the difference Between Mapping parameter and variable

Accenture,

3 10849

What is update override?

Accenture,

1 7071

Un-Answered Questions { Data Warehouse }

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

1231

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

1196

Hi, If anyone has base SAS certification dumps, please share.

1936

How to add default rules in transformer?

1284

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

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

2331

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

4018

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

1172

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

2303

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

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

1118

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

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

2858

Explain how to generate iqd file from framework manager?

1020

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1961

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