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 decide whether u need to do aggregations at database level or at Informatica level?

1 4305

how would u estimate the size of Lookup transform data and index cache?

1 3952

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 4688

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2895

how do u really know that paging to disk is happening while u are using a lookup transform?

2432

how do u set partition points in the mapping?

Quintiles,

2245

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

1 3729

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

what is meant by drill through?(Mascot)

1 4301

what is pmrep command?

2443

what happens if the info.server doesn't find the session parameter in the parameter file?

2 5064

Can u access a repository created in previous version of Informatica?

DELL,

1 5543

Eliminating of duplicate records without using dynamic lookups

1 4302

what are Lookup caches options? Including persistent caches.

1 4709

Difference between flat files and relational sources?

2316

Un-Answered Questions { Data Warehouse }

What is intricate mapping?

1213

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1966

What is defined as Query studio?

1112

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2073

What is ibm datastage?

973

What is apt_config in datastage?

1142

Explain what are the tasks that loadmanger process will do?

931

How can we create index after completion of load process?

1127

What is a folder? Difference types of stages?

1179

Do you need to rearrange the order of the data for the report?

2311

If you want to use a same piece of code in different jobs, how will you achieve this?

1278

Clarify the utilization of aggregator cache record?

1006

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1082

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3652

Target increases every day even though no new record was inserted

1589

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