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
- 13304 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / savita
hi guys,
some one selected that Above ans is worng.. can any one
tell correct answer.for the above Question
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / krishna
hey raj, pooja and savita the costliest transformatin till
Infa7.1.4 is lookup but after Infa 8.1 it guess it sj=hould
be JAVA.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / pooja
HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3
aGGREGATOR IS COSTLIEST TRANS
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / raghu
aggregater is costliest bcoz it have cache, remaing d'snt
have cache
| Is This Answer Correct ? | 0 Yes | 6 No |
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
What are the features of complex mapping?
What is different between informatica version 8 and 9 version
without using emailtask how will send a mail from informatica?
What are the unsupported repository objects for a mapplet?
Can we create a node as a gateway node and the same node can be assigned to a grid?
enterprise datawarehouse your project phase by phase explain?
What is diff joiner and lookup
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
why we use informatica in our project?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Teradata 
