Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Define pmcmd command?

1025


What is meant by LDAP users?

1170


What is an unconnected transformation?

1065


What is target designer and target load order?

1088


Explain lookup transformation in informatica

1049


How to load data in informatica ?

987


What is an expression transformation?

999


Where is metadata stored?

1093


What is the benefit of partitioning a session?

1159


What is target load order?

1225


Explain in detail about scd type 1 through mapping.

1416


Suppose we do not group by on any ports of the aggregator what will be the output?

1029


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1677


How do you load first and last records into target table?

1140


What does reusable transformation mean?

1118