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..
- 7 Answers
- 13615 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
HI
Among those 3 trans, filter does not use cache.
so it should be either agg or sorter.
Both agg and sorter uses cache as they process data in a
dependable fashion for performing calculations and sorting
data before the result is passed to next transfomration.
WE cant say which one uses more space. it depends on the
size of source data we are processing.
Agg needs to perform calculations on groups of data but if
the data in sorter is more, it takes more space than agg to
hold the data.
for ex, we are sorting on character data, server needs to
use ASCII values of alphabets to sort in order.
It depends on the size of the source data.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
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
How we can create indexes after completing the load process?
Differentiate between a database and data warehouse?
What is the Rank index port in Rank transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What all join we can perform in LOOKUP transformation?
What are the types of schemas we have in data warehouse.
Explain the features of connected and unconnected lookup.
What are pre and post-session shell commands?
What is the command used to run a batch?
What are the guidelines to be followed while using union transformation?
Explain what are the different types of transformation available in informatica.
How to load the data from people soft hrm to people soft erm using informatica?
What is a code page?
What are the different types of olap? Give an example?
