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 5991

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

IBM,

3 7148

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 7862

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

IBM,

2 6022

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

Polaris,

2 6524

What is process model?

1986

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

2129

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

2 9923

what is .dsx files

IBM,

3 12348

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,

2543

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 10332

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

IBM,

2 8670

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

CSC, HY,

1 10463

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

1904

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

Amdocs,

1 3310

Un-Answered Questions { Data Warehouse }

What are the scenarios in which full table scans occurs?

1011

What is the difference between the content store and content manager?

1043

How many types of views are there in a datastage director?

1296

----------------------What are the User Securities?

1858

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

2510

Explain what does level of granularity of a fact table signify?

961

define over feeding?

Explain Quality stage?

1162

Does redshift support unstructured data?

COM components can be used in Informatica

2397

What are the stages that are required in data warehousing?

964

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2279

What are Aggregate tables?

1181

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2036

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