1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


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 17123

difference between shortcut and reusable transformation?

 2 9014

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 20846

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 3737

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 7980

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 7061

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 3917

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

JPMorgan Chase, Wipro,

2 25333

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

JPMorgan Chase,

3 25161

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 5477

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

IBM,

3 8096

Which is the optimized method of extracting the data.

 3 5860

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 3471

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 4769

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

 4 6645

Un-Answered Questions { Data Warehouse }

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1489

What do you mean by mstr? What are the different types of mstr objects?

567

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

527

How abinitio eme is segregated?

796

What is a dimension?

625




what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

538

What is the fact table?

584

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

560

Demonstrate experience in maintaining quality process standards?

1918

Can you explain the advantage of using shortcuts?

607

How can create users and permissions in cognos?

554

What do you mean by static prompt report?

553

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2134

Explain difference between powerplay transformer and power play reports?

535

Can you explain tagbatch restructure operator?

697

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