what is the drillup & drill down?and use of the drill up and
drill down?



what is the drillup & drill down?and use of the drill up and drill down?..

Answer / megha bagaria

Drill up is when you are drilling lower level data to the upper level to check for the aggregated value where as drill down is when you are drilling from higher level to lower level to check if the distributed lower level values are correct or not when aggregated at the upper level.

Thanks and Best regards,
------------------------------------------------------------
Megha Bagaria | InfoCepts Technologies Pvt Ltd
------------------------------------------------------------

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

without table how to come first record only in oracle?

0 Answers  


If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,


Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


what is the size of u r source(like file or table)?

0 Answers   HP,






Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


What is joiner change?

0 Answers  


What is a taget load order?

2 Answers   IBM,


Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


what is lookup chache?

1 Answers   Patni,


how many ways can we implement SCD2?

4 Answers   IBM, TCS,


What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,


Categories