which one is costliest transformation? costliest means
occupying more memory. which one
Aggregator,sorter,filter,etc..
Answer Posted / 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 |
Post New Answer View All Answers
Define pmcmd command?
What is meant by LDAP users?
What is an unconnected transformation?
What is target designer and target load order?
Explain lookup transformation in informatica
How to load data in informatica ?
What is an expression transformation?
Where is metadata stored?
What is the benefit of partitioning a session?
What is target load order?
Explain in detail about scd type 1 through mapping.
Suppose we do not group by on any ports of the aggregator what will be the output?
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.
How do you load first and last records into target table?
What does reusable transformation mean?