What is the difference between a shortcut of an object and copy of an object? Compare them.
Answers were Sorted based on User's Feedback
Answer / rj
in case of shortcut u cant make any change in it directly.U need to make the change in the original object .while in case of copy the change will get reflected in the original object if u make any change in the copied object.
Is This Answer Correct ? | 1 Yes | 0 No |
Nikhil....you have said it completely wrong. If we change in Shortcut, it will reflect in the source. Whereas in case of copying, the source will not change if we change something in the copied object.
Copy can be done between 2 Normal folders objects or between a Shared and a Normal folder.
Shortcut's can be done from a Shared folder to Normal folder only.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nikhil
Shortcut is used the common folder used to import any source,target and mapping physically, and that object we can use in our mapping locally, when you made any changes it will not reflect in the common folder so you save your source from being changed.
Whereas
In case of copy you actually copy the physical object so if you made any changes in any source,target and mapping it will be reflected in all the mapping whereever it is being used.
Is This Answer Correct ? | 0 Yes | 1 No |
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..
List the transformation in informatica.
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
How can you increase the performance in joiner transformation?
can you please explain me pre session and post session options?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
what is informatica metadata?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is event and what are the tasks related to it?
How does the session recovery work.
Can you copy the session to a different folder or repository?
What is joiner change?