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 |
How to generate a single mapping for both the historical and incremental load.
What is informatica? What exactly are the practical uses in real world
What is the need for an etl tool?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
tell me 5 session failure in real time how can you solve that in your project?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
COM components can be used in Informatica
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
After we make a folder shared can it be reversed?Why?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Explain the etl program with few examples.
why dimenstion tables are denormalized in nature ?