Which is costliest transformation? costly means occupying
more memory?
Answers were Sorted based on User's Feedback
Answer / subhransu,bangalore
costly means consuming more memory.which transformation have cache memory.
example:lookup TR
sorter TR
aggregator TR
rank TR
joiner TR
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / soujanya
costliest means occupying more memory.
filter
sorter
aggregator
rank
lookup
the transformations having cache memory
| Is This Answer Correct ? | 0 Yes | 3 No |
What are the options in the target session of update strategy transsformatioin?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
What is aggregate cache in aggregator transformation?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What is the Rank index port in Rank transformation?
What is Target Update Override? What is the Use ?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
explain about session partitions ?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
how to use incremental load?
Different circumstance which drives informatica server to expel records?