which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / jyothiram
XML is costliest transformation after sorter.
XML--- 10 units
sorter---8 units
lkup,joiner,agg,rank-(index)-1 unit
lkup,joiner,agg,rank-(data)-2 unit
These are the order of costlier in cache making
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is deployment group?
Explain transaction control transformation in informatica
Explain the features of connected and unconnected lookup.
Explain sessions. Explain how batches are used to combine executions?
How to delete duplicate row using informatica?
can you please explain me pre session and post session options?
What is event and what are the tasks related to it?
What does role playing dimension mean?
Explain the different kinds of facts.
State the differences between sql override and lookup override?
can we override a native sql query within informatica? Where do we do it?
To import the flat file definition into the designer where should the flat file be placed?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Make a note of the quantity vaults made in informatica?