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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can a transformation be made reusable?

660


how to create user defined function (udf) in informatica

782


What do you mean by enterprise data warehousing?

639


Explain scd type 3 through mapping.

577


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1590






How can repository reports be accessed without sql or other transformations?

722


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1534


Explain the use of aggregator cache file?

672


What do think which one is the better joiner or look up?

723


How can we improve session performance in aggregator transformation?

671


What is the different lookup cache(s)?

610


What are the different types of repositories created using informatica?

654


Enterprise data warehouse your projects phase by phase explain?

1459


Different sorts of metadata that stores in the storage facility?

555


What is the meaning of up gradation of repository?

1387