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

difference between source based commit? and target based commit? which is better with respect to performance?

IBM,

6 19327

difference between shortcut and reusable transformation?

2 10230

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23913

Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 4575

If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

Extech, Principal Finance,

3 9468

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

Principal Finance, PT Metalogix Infolink Persada,

1 7883

working with Business Objects 6.1(a), i m facing a problem. when i save the BO report containing chart aswell as table in .xls then the null vlues in the table automatically are converted to 0, thereby istorting the chart also. please provide me the solution as soon as possile.

1 4736

What is max core value ? what is the use of it?

JPMorgan Chase, Wipro,

2 27104

In Join component which record will go to unused port and which will go to reject port ?

JPMorgan Chase,

3 27116

What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 6633

if we increase the number of dimensions will the rows in fact table increase or decrease??

IBM,

3 9724

Which is the optimized method of extracting the data.

3 7466

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 4291

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

IBM,

1 5643

Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.

4 8194

Un-Answered Questions { Data Warehouse }

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1199

Design time, run time. If you don't create parameter what will happen

1895

Define report item?

1254

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1109

What are the key benefits of ETL Testing?

1101

What is primary and backup node?

1174

Explain what is a cube in data warehousing concept?

1034

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277

What are teradata utilities?

1158

What is a node in teradata? Explain

1054

what is granularity in Data ware House?

1792

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4445

What are the differences between a connected lookup and unconnected lookup?

1127

What will be the approach?

1039

What is called dimensional modelling?

1188

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