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 reusable transforamtions?
why we use source qualifier transformation?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Can we combine a flatfile and a database table using an UNION transformation?
how can we calculate fact table size?
why we are using level option in normalizer transformation
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
what is data modelling? what are types of modelling?In which suituation will use each one?
Performance wise which is better joiner or look up ? Give me with example?
What are the main issues while working with flat files as source and as targets ?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate