which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
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
How will the document be delivered to me?
What is an active transformation?
How can we remove the duplicates from flat file source?
What are the modules in Power Center
What is informatica? Why do we need it?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is meant by lookup transformation?
Explain what are the different types of transformation available in informatica.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how many types of dimensions are available in informatica?
What is the fact table?
What are the types of caches in lookup? Explain them.
can anyone suggest best free Talend data integration training online
What is the cumulative sum and moving sum?