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 6093

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

IBM,

3 7269

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 8003

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

IBM,

2 6110

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

Polaris,

2 6648

What is process model?

2028

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

2188

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

2 10041

what is .dsx files

IBM,

3 12484

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,

2592

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 10503

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

IBM,

2 8802

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

CSC, HY,

1 10589

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

1948

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

Amdocs,

1 3396

Un-Answered Questions { Data Warehouse }

What is Sequence clustering algorithm?

2074

where to store informatica rejected data?

1141

which date functions advances a date time or date/time value by a given interval? : Sas programming

1011

what are the different authentication modes available in microstrategy?

1181

explain the use of % includes a statement in sas? : Sas-administrator

1052

which type of project we r going to snowflake schema

2027

What are the design methods of data warehousing?

1008

Briefly explain the aggregator transformation?

1068

what is star schema? : Sas-di

1190

Explain about ab initio’s dependency analysis?

1246

What are all the types of hierarchies?

1181

How to select first n records in teradata?

1168

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

1037

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1076

write a query to retrieve the latest records from the table sorted by version(scd)

1125

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