which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / cooldude
Sorter will be costliest transformation as it uses
temporary cache and its size is approximately to the size
of RAM.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain lookup transformation is active in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Design time, run time. If you don't create parameter what will happen
Slowly changing dimensions, types and where will you use them
As union transformation gives UNION ALL output, how you will get the UNION output?
What is informatica powercenter repository?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What does cheating measurement mean?
How do you load unique records into one target table and duplicate records into a different target table?
How to create a non-reusable instance of reusable transformations?
Difference between Target-based loading and constraint-based loading?
What is union transformation?
What is meant by lookup transformation?