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
What is resilience time?
what is the Default Source Option For Update Strategy Transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are some examples of informatica etl programs?
What are junk dimensions?
What do you understand by a term domain?
What are the types of lookup transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain pushdown optimization $pushdownconfig parameter - informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can one identify whether mapping is correct or not without connecting session?
can we override a native sql query within informatica? How do we do it?
What are the different types of olap? Give an example?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.