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 |
how to join the 2 different table with different columns in informatica?
In update strategy target table or flat file which gives more performance ? why?
What is the difference between source qualifier transformations source filter to filter transformation?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What are the tuning techniques you applied during your last project
Why we select the table which has minimum number of records as Master table in joiner?
What is the need for an etl tool?
What are the challenges you have faced in your project?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Why touse stored procedure in ETL Application?
can we use mapplet as starting n ending object in mapping