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

What are Target Options on the Servers?

1 6058

What is Code Page Compatibility?

1 8892

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42379

Why we use lookup transformations?

1 6325

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

TCS,

5 19132

Explain about perform recovery?

1 6814

How to recover sessions in concurrent batches?

1 12273

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 6419

How to recover the standalone session?

2 9478

What is difference between maplet and reusable transformation?

2 9981

What are the data movement modes in informatcia?

3 7619

What are the out put files that the informatica server creates during the session running?

2 7870

What are the types of maping in Getting Started Wizard?

1 5737

What are the different types of Type2 dimension maping?

CTS,

2 10388

Can you generate reports in Informatcia?

1 5775

Un-Answered Questions { Data Warehouse }

what is the meaning of ending bulk load mode?

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5453

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

921

Difference between data warehousing and olap?

1097

what is the main role of FI on business

2107

What are the different servers in sas? : sas-grid-administration

1059

What is brodcasting and replicate?

1214

What is the role of administrative users? : sas-grid-administration

1084

what is factor analysis? : Sas-administrator

1104

How to enable drills in a given column data?

857

Name different type of objects in microstrategy?

933

how do u implement configuration management in Informatica?

4797

name the components of report net?

How can you validate all mappings in the repository simultaneously?

1372

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

1868

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