which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
- 7 Answers
- 12018 Views
- TCS, I also Faced
- E-Mail Answers
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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is persistent lookup cache?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is joiner change?
What is the format of informatica objects in a repository?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Please let me know how to make Data masking in informatica..
Where is metadata stored?
How to generate sequence numbers without using the sequence generator transformation?
Explain the etl program with few examples.
Which version configuration tool used in ur project?
How do you load only null records into target? Explain through mapping flow.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
