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 |
Which transformation should we use to normalise the COBOL and relational sources?
How can you run a session without using server manager?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What is informatica worklet?
what is dynamic cashe
checkout and checkin in informatica 8.6
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Under which circumstances, informatica server creates reject files?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?