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

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,


Define update strategy?

0 Answers  


when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 Answers  


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  






What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  


What are the different ways to implement parallel processing in informatica?

0 Answers  


what is incremental data aggregation?

3 Answers   IBM,


what is INFORMATICA TESTING process

0 Answers  


What is the benefit of session partitioning?

0 Answers  


How to load relational source into file target?

3 Answers   IBM,


Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  


Categories