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 6151

What is Code Page Compatibility?

1 8958

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42544

Why we use lookup transformations?

1 6397

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

TCS,

5 19334

Explain about perform recovery?

1 6907

How to recover sessions in concurrent batches?

1 12412

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

2 6523

How to recover the standalone session?

2 9580

What is difference between maplet and reusable transformation?

2 10092

What are the data movement modes in informatcia?

3 7752

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

2 7958

What are the types of maping in Getting Started Wizard?

1 5821

What are the different types of Type2 dimension maping?

CTS,

2 10462

Can you generate reports in Informatcia?

1 5846

Un-Answered Questions { Data Warehouse }

Name the different sorting methods in datastage.

1108

Explain how you can debug and test your SAS program?

1054

What is meant by incremental load?

1163

Which transformation should we use to normalise the COBOL and relational sources?

1274

What problems have you faced while working with amazon redshift?

Your account is locked and your administrator has forgotten the password. What would you do?

1108

Your application mode has crashed. How would you get the instance back?

1005

How to load data in informatica ?

1070

What is the syntax for m_dump in abinitio?

1680

How to provide security in frame work manager for a query subject?

1014

What is Sequence clustering algorithm?

2074

can you tell me what are the dimension tables are used in project

2363

what are 3 tech challenges/ common issues you face?

2397

What is spool space? Why do you get spool space errors?

1088

what are the basic features of cognos tm1?

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