which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
- 7 Answers
- 11606 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 |
how to through logic of informatica using the push down optimization into oracle.
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What is meant by lookup transformation? Explain the types of lookup transformation?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
What is log file,and where is it located,why u r using the log file
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
What is a poling?
How do you migrate data from one environment to another?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Teradata 
