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 17102

difference between shortcut and reusable transformation?

 2 8985

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 20815

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 3723

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 7962

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 7050

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 3901

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

JPMorgan Chase, Wipro,

2 25310

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

JPMorgan Chase,

3 25129

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 5458

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

IBM,

3 8078

Which is the optimized method of extracting the data.

 3 5847

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 3463

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 4762

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

 4 6629

Un-Answered Questions { Data Warehouse }

What do you mean by drill through report?

568

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1115

What are the conditions needed to improve the performance of informatica aggregator transformation?

570

What are the prime responsibilities of data integration administrator? : Sas-di

578

What are the job parameters?

692




What are the types of Data Warehouse applications?

505

list out all the transformations which use cache?

675

What are the differences between sum function and using “+” operator?

561

What are types of partition primary index (ppi) in teradata?

577

what are factless facts? And in which scenario will you use such kinds of fact tables.

1295

How to create Index to the table in the universe designer and how it improves the Query performence

2102

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

609

What does reusable transformation mean?

654

how many types prompting framework can be broken down to? : Sas-bi

612

How we are using this function?

583

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