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 do u validate the program which u have written.

TCS,

1 5983

how to change the colour of the bar in charts...?

IBM,

3 7141

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 7857

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

IBM,

2 6012

Hi, How the relations will be exists in DMR models if u have any idea please explain me

Polaris,

2 6520

What is process model?

1977

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2120

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 9917

what is .dsx files

IBM,

3 12336

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

DELL,

2534

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

DELL,

5 10318

what is the difference between primary index and secondary index?.

IBM,

2 8669

What are the unit test cases you used in your project?

CSC, HY,

1 10459

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

1899

What is the role of informatica in project ?Like i showed financial projects?

Amdocs,

1 3306

Un-Answered Questions { Data Warehouse }

How you Implemented SCD Type 1 & Type 2 in your project?

4129

design of staging area?

2030

What is the difference between using drop = data set option in data statement and set statement?

1164

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1344

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2339

What are the join problems comes appart from loop,chasm & fan Traps

2132

What is the difference between a cascading report and drill through the report?

1174

How will you monitor the errors received while running i-server and report?

947

How do you set the session mode parameters in bteq?

1103

Explain how to import oracle sequence into informatica?

1012

what are the Methods For Creating Reusable Transformations?

1173

How can we update a record in the target table without using update strategy?

1149

What is meta stage?

1182

What is fact degradation?

976

What interface is used to connect to windows based applications?

1114

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