which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
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 |
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
how to sort date field in infomatica?
What is the difference between informatica 8.x and 9.x
When to use normalization transformation other than cobol source?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
draw informatica architecture 8.6 ?
what is $$$$?
without matching columns in two tables. how can you join
Tell me about MD5 functions in informatica
what is the difference between Informatica 7.1 and Abinitio?
How to eliminate duplicates in FF and oracle both