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

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 7052

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

Accenture,

7 12819

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

CTS,

2 5983

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

Pfizer,

2071

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

Pfizer,

1 5470

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 6096

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 12586

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

HCL,

1 4857

Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 5001

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

IBM, Wipro,

4 13669

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

TCS,

1 8333

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

TCS,

1 6591

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

IBM, TCS,

3 13804

Give example for FACTLESS FACT TABLE in real-time scenario.

TCS,

4 19014

How many jobs in ur project? Explain any complex job u have done in ur project?

IBM, TCS,

1 5213

Un-Answered Questions { Data Warehouse }

permutations of mapplet

2512

What is the difference between match merge and one to one merge?

1253

complex mapping ur project u r invlve can u explain and give real time example give me ?

2307

What is meant by active and passive transformation?

1127

In Which Transformation We Can Use Having Clause In Informatica?

1243

What are the different ways to implement parallel processing in informatica?

1426

What do you understand by a term domain?

1126

What is a dimensional model?

986

Explain the etl program with few examples.

1054

Triggers,VIEW,Procedures

1225

What are the issues you have faced in your project? How did you overcome those issues?

2365

What is the maplet?

1127

What is workflow? What are the components of the workflow manager?

1146

What is data caches/ index caches?

1108

Explain and compare pros and cons of snow flake schemas?

1035

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