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 19126

difference between shortcut and reusable transformation?

2 10108

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23593

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 4494

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 9301

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 7802

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 4659

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

JPMorgan Chase, Wipro,

2 26954

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

JPMorgan Chase,

3 26956

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 6538

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

IBM,

3 9585

Which is the optimized method of extracting the data.

3 7339

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 4219

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 5555

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

4 8036

Un-Answered Questions { Data Warehouse }

What is the difference between dependent data warehouse and independent data warehouse?

1007

which r the connectors used in san?

2188

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1077

What is "method/1"?

1057

Difference between stored procedure and macro?

1172

List the logical and conditional operators that are used with teradata along with their meanings?

1001

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

1136

Is there any target staging area in informatica not staging area

2578

differentiate between power play transformer and power play reports?

Can you define set to be cardinality?

1011

What is a dw? Why do we need it?

976

Is it possible to get a floating window in microstartegy web? If yes, how?

1156

How do you optimize reports in microstartegy?

1109

How to drill through from a powerplay cube to reportnet?

937

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

835

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