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 18961

difference between shortcut and reusable transformation?

2 10019

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23374

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 4442

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 9165

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 7750

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 4609

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

JPMorgan Chase, Wipro,

2 26825

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

JPMorgan Chase,

3 26832

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 6455

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

IBM,

3 9466

Which is the optimized method of extracting the data.

3 7220

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 4141

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 5506

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

4 7930

Un-Answered Questions { Data Warehouse }

how do the in= variables improve the capability of a merge? : Sas programming

1415

How to read an input file in sas?

1113

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

1185

Explain and compare pros and cons of start schemas?

1006

How to compare two dmls in abinitio

1804

What is the difference between round-robin partitioning and hash partitioning?

942

What are the automatic variables for macro? : sas-macro

1181

Can we configure two instances of CMS pointing to two different CMS system databases?

1986

Explain the difference between keylokup and joiner?

861

What is the use of cognos decision stream?

1053

what do u mean by bridge group? where we r using this one?

1932

What is the primary index in teradata?

1147

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1034

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

786

What is the extension of file to save template?

978

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