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 42371

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 12269

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 7615

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 5773

Un-Answered Questions { Data Warehouse }

Explain fact structure?

986

What is target load order?

1246

Give some difference between oltp and olap.

1008

Define query studio?

1003

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2005

What is the difference between datastage and informatica?

1118

How to fine tune mappings?

941

What is the difference between check point and phase?

1309

What are the ways in which macro variables can be created in sas programming?

1103

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

What do you understand by the term 'aggregate advisor?'

963

What do you mean by filter transformation?

951

Describe the function and untility of the most difficult SAS macro that you have written.

2217

Difference between inner join and outer join?

1026

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1266

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