Sorter will be costliest transformation as it uses temporary cache and it

which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..

Question Posted / cooldude

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

Please Help Members By Posting Answers For Below Questions

What are the types of schemas we have in data warehouse and what are the difference between them?

950

What are the types of data warehouses?

1529

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7465

What is a pre-defined event and user-defined event?

1049

What is domain in terms of informatica?

1013

Explain pmcmd command usage in informatica

1141

What does role playing dimension mean?

1052

Explain Dataware house architecture .how data flow from intial to end?

2592

What are the limitations of joiner transformation?

1115

explain about unit testing? in real time?

2211

hi real timers . iam waiting for ur reply regarding ETL TESTING

2277

How to load the data from people soft hrm to people soft erm using informatica?

1026

What is a rank transform?

1093

Target increases every day even though no new record was inserted

1591

What is informatica metadata and where is it stored?

999