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 ?

1 2092

can be used COM component in Informatica ?

1 2125

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

2 4915

when will use SQL override in a lookup transformation?

1 2359

Two different admin users created for repository are________and_________.

1 3997

Two default user groups created in the repository are____and_____.

1 2124

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?

1 1932

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.

1 2147

what is the difference between date cache and lindex cache?

1 3977

when should one create lookup transformation ?

2 5620

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

1 4797

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

1 2180

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 6497

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

1 2517

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

1 2072

Un-Answered Questions { Data Warehouse }

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

what is document design in boxi,have u participate in that

2306

What is the difference between business requirement document and use case document.

1083

What is the purpose of Dataware Control?

1121

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1997

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2094

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1239

how many reports have u created ? explain a few.

2160

Hi, If anyone has base SAS certification dumps, please share.

1938

what are the data modeling tools you have used?(polaris)

2058

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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