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

why we use datawarehouse

HCL,

2045

why we need informatica

HCL,

2 13660

what is degenerated dimension table with scenario

HCL,

2 3811

Explain factlessfact table with scenario

HCL,

1 3486

What is confirmed dimension with scenario

HCL,

1 3523

Diffrence between static and dynamic cache

HCL,

2 6596

If u r using dynamic cache lookup port will be thier in thet which option u will select

HCL,

1 3532

What is souce qualifier transformation it is active or passive

HCL,

2 10596

What is an aggregator transformation? it is active why cant it be passive explain?

HCL,

3 18273

Diffrence between 7.1,8.1 and 8.6

HCL, Wipro,

3 12035

How the dimensions will be loaded?

HCL,

2173

How the facts will be loaded? explain

HCL,

2 8338

What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?

HCL,

1 6044

What is partioning?how many types of partinings are there

HCL,

2 7693

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

HCL,

2 5686

Un-Answered Questions { Data Warehouse }

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

1849

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2824

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

2057

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

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

1080

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

What is a rollup component? Explain about it.

1241

How to create the source and target database connections in server manager?

1144

What is the purpose of Dataware Control?

1119

explain in detail about type 3?

1083

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