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 5953

What is Code Page Compatibility?

1 8802

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42235

Why we use lookup transformations?

1 6230

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

TCS,

5 18925

Explain about perform recovery?

1 6701

How to recover sessions in concurrent batches?

1 12125

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

2 6285

How to recover the standalone session?

2 9350

What is difference between maplet and reusable transformation?

2 9851

What are the data movement modes in informatcia?

3 7471

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

2 7752

What are the types of maping in Getting Started Wizard?

1 5657

What are the different types of Type2 dimension maping?

CTS,

2 10254

Can you generate reports in Informatcia?

1 5694

Un-Answered Questions { Data Warehouse }

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3419

Which files are created during the session rums by informatics server?

1130

In Teradata, how do we Generate Sequence?

989

What are the implications?

1639

Mention a few of the ETL tools that come under Teradata.

1024

How do you improve the performance of the Cognos Analytics report

979

Which means the first record should come as last record and last record should come as first record and load into the target file?

1028

When can we choose the Redshift ?

What is datastage?

1040

What is the difference between informatica 7.0 and 8.0?

958

Explain dynamic target flat file name generation in informatica

1015

What DB View and Bus View?

1938

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1889

What is meant by a Clique?

1002

what are validation tools that are used in sas? : Sas-administrator

1010

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