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 7221

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 13073

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 6103

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

Pfizer,

2122

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

Pfizer,

1 5556

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 6231

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 12724

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

HCL,

1 4947

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

2 5118

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

IBM, Wipro,

4 13850

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 8427

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 6731

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

IBM, TCS,

3 14004

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

TCS,

4 19183

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

IBM, TCS,

1 5364

Un-Answered Questions { Data Warehouse }

Explain is there any default username & pwd for bo designer & supervisor?

1069

What is the difference between the local container and shared container?

1154

What is etl tool in hadoop?

963

Explain fact?

1034

what is the complex transformation you used in informatica

2631

How to delete duplicate row using informatica?

1096

What are data modeling and data mining? Where it will be used?

1032

Explain about Informatica server process that how it works relates to mapping variables?

1132

Why do we use link partitioner and link collector in datastage?

1200

Name the third party tools that can be used in datastage?

1149

Explain what is the metadata extension?

1110

What is amazon redshift?

Can you define report item?

1111

How can we do data cleaning?

1111

What is Cognos script editor?

2623

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