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 will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
How to do unit testing in informatica?
What are the tasks that source qualifier perform?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
What is joiner transformation?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
What are the new features of Power Center 5.0?