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

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  


what are the limitation of sorter transformation?

2 Answers   TCS,


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  






I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,


how many types of dimensions are available in informatica?

0 Answers  


Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


Types of error logs in Informatica?

2 Answers  


Categories