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
What is workflow? What are the components of the workflow manager?
Why is sorter an active transformation?
What are the restrictions of union transformation?
Explain pushdown optimization and types in informatica
What does update strategy mean, and what are the different option of it?
Define mapplet?
Explain what is informatica metadata and where is it stored?
explain abt ur project architecture?
Define the various join types of joiner transformation?
Explain the different lookup methods used in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
write a query to retrieve the latest records from the table sorted by version(scd)
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not