which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / 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 |
Post New Answer View All Answers
Write the program through which the records can be updated?
What is the difference between router and filter?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the types of caches in lookup?
How do you migrate data from one environment to another?
what is the Default Source Option For Update Strategy Transformation?
What are the different transaction levels available in transaction control transformation?
Differences between connected and unconnected lookup?
How to extract the informatica rejected data?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
define galaxy repository in informatica
What are the uses of etl tools?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Can u generate reports in Informatica?