Answer Posted / meera
creating copies takes extra memory. it is anlaogus to have a complete duplicate of the mapping. whereas shortcut refers to the refrence for the mapping. when creating shortcut memory is not used up . and any change made to the original reference (mapping) will be reflected in the shortcut.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
Define the various join types of joiner transformation?
What is the format of informatica objects in a repository?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a pre-defined event and user-defined event?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the various types of transformation?
What is data movement mode in Informatica and difference between them?
What is a surrogate key?
How to improve the performance of a session using sorter transformation?
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?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain joiner transformation in informatica
What is data caches/ index caches?