which one is costliest transformation? costliest means occupying more memory.

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..

Question Posted / raja

7 Answers
12016 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

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

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

Answer / pooja

HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3
aGGREGATOR IS COSTLIEST TRANS

Is This Answer Correct ?

2 Yes

6 No

which one is costliest transformation? costliest means occupying more memory. which one Aggregat..

Answer / raghu

aggregater is costliest bcoz it have cache, remaing d'snt
have cache

Is This Answer Correct ?

0 Yes

6 No

Post New Answer