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


Please Help Members By Posting Answers For Below Questions

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

634


Explain lookup transformation is active in informatica

665


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

1760


Design time, run time. If you don't create parameter what will happen

1428


Slowly changing dimensions, types and where will you use them

1278






As union transformation gives UNION ALL output, how you will get the UNION output?

651


What is informatica powercenter repository?

716


4 yrs etl devloper roles and responsibilities?any body give solutions

1585


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1790


What does cheating measurement mean?

601


How do you load unique records into one target table and duplicate records into a different target table?

712


How to create a non-reusable instance of reusable transformations?

686


Difference between Target-based loading and constraint-based loading?

557


What is union transformation?

576


What is meant by lookup transformation?

617