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 we will Developing new reports Using Data step programming and Macros ?

4 6596

why do u use shortcuts in informatica.?

iFlex,

4 29206

how do u move the code from development to production?

6 12985

what is confirmed dimension?

6 14033

Kimball and Inmon methodologies?

2 17123

star and snowflake schema?

6 13754

surrogate keys usage in Oracle and Informatica?

ITC Infotech, Oracle,

5 15981

scd methodology?

2 6303

version controlling in informatica?

3 18057

what r the values tht r passed between informatics server and stored procedure?

1 5484

what is parallel querying and what r hints.

1 5518

what happens when a batch fails?

3 8579

connected and unconnected lookups?

4 8802

what is scd?

6 17998

what are surrogate keys?

5 11731

Un-Answered Questions { Data Warehouse }

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

Write the unconnected lookup syntax?

1139

What is dimensional table? Explain the different dimensions.

1262

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4183

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

2161

what are the names of the reports that you prepared?

1185

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838

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

1193

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

1073

faq's on cognos

4108

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

1654

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

how many reports have u created ? explain a few.

2152

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2289

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