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 18899

difference between shortcut and reusable transformation?

2 9966

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23282

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 4410

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 9100

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 7724

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 4577

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

JPMorgan Chase, Wipro,

2 26768

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

JPMorgan Chase,

3 26771

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 6400

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

IBM,

3 9397

Which is the optimized method of extracting the data.

3 7159

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 4111

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 5483

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

4 7870

Un-Answered Questions { Data Warehouse }

Explain difference between onrow and onread method?

845

What are the main issues while working with flat files as source and as targets ?

1099

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3558

Define bulk load mode?

define drill through?

Does datastage support slowly changing dimensions ?

1054

Why denormalization is promoted in universe designing?

945

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2124

What are key differences between sql server and amazon redshift?

what is Forward,Reverse and Re_engineering?

2128

List down the reasons for choosing sas over other data analytics tools.

1214

what is the difference steps for data modeling?

2049

What is static prompt in microstrategy?

919

What are the newly developed features of Teradata?

973

How do you control the number of observations and/or variables read or written?

1193

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