Why use shortcuts(Instead of making copies).
Answer / 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 |
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is aggregate awareness?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
what is the significance of newlookup port in dynamic look up
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
how to get the only updated records in the target
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
Name 4 output files that informatica server creates during session running?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..