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 6055

What is Code Page Compatibility?

1 8884

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42370

Why we use lookup transformations?

1 6319

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

TCS,

5 19128

Explain about perform recovery?

1 6802

How to recover sessions in concurrent batches?

1 12268

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

2 6411

How to recover the standalone session?

2 9476

What is difference between maplet and reusable transformation?

2 9972

What are the data movement modes in informatcia?

3 7614

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

2 7863

What are the types of maping in Getting Started Wizard?

1 5735

What are the different types of Type2 dimension maping?

CTS,

2 10384

Can you generate reports in Informatcia?

1 5772

Un-Answered Questions { Data Warehouse }

Explain how to export mappings to the production environment?

977

What is the function of output statement in a SAS Program?

1074

What are the different options available for update strategy?

1003

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1084

Which development components of informatica have the highest usage?

1043

Difference between sequential file and data set?

1201

How co>operating system integrates with legacy codes?

1175

What are the important Features of Redshift?

What are the different types of parallelism in ab initio?

1221

What are the types of hierarchies?

1025

what is transformation in sas data integration? : Sas-di

1036

How much data hold in one universe.

994

Explain substr function?

1110

While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

925

What is static prompt in microstrategy?

973

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