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

can cubes contain measures ?

2044

can be used COM component in Informatica ?

2072

what is the advantage of persistent cache? when it should be used?

2 4796

when will use SQL override in a lookup transformation?

2310

Two different admin users created for repository are________and_________.

1 3933

Two default user groups created in the repository are____and_____.

2063

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1878

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2079

what is the difference between date cache and lindex cache?

1 3906

when should one create lookup transformation ?

2 5501

how do u handle performance issues in Informatica . where can u monitor the performance ?

4756

list and discuss two approaches for updation of target table in Informatica and how they are different.

2123

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 6382

where are the log files generally stored.Can you change the path of the file.what can the path be?

2454

where is the cache (lookup, index) created and how can you see it.

2029

Un-Answered Questions { Data Warehouse }

How can you force the optimizer to use a particular index?

1084

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2051

What are sequencers?

1143

Where do you use proc means over proc freq?

1136

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2778

Explain fact structure?

999

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1019

Explain the difference between view and materialized view?

954

What are the steps to build the datawarehouse?

1054

what is pmrep command?

2449

Explain the difference between the truncate and delete commands?

1181

What are report filters and view filters?

963

Name the different types of Lookups in Datastage?

1278

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2233

Explain what are the basic needs to join two sources in a source qualifier?

1159

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