Interested to Buy Any Domain ? << Click Here >> for more details...
difference between shortcut and reusable transformation?
- 2 Answers
- 9957 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
A shortcut is a reference (link) to an object in a shared
folder, these are
commonly used for sources and targets that are to be shared
between
different environments / or projects. A shortcut is created
by assigning
'Shared' status to a folder within the Repository Manager
and then dragging
objects from this folder into another open folder; this
provides a single
point of control / reference for the object - multiple
projects don't all
have import sources and targets into their local folders.
A reusable transformaion is usually something that is kept
local to a
folder, examples would be the use of a reusable sequence
generator for
allocating warehouse Customer Id's which would be useful if
you were loading
customer details from multiple source systems and
allocating unique ids to
each new source-key. Many mappings could use the same
sequence and the
sessions would all draw from the same continuous pool of
sequence numbers
generated.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / krithi
Shortcuts allow you to share multiple objects within the
repository i.e., we can use an object in the shared folder
without creating or copying. If the original object
changes, the shortcuts reflects the changes.
Whereas a Reusable Transformation can be used only within
the mappings in that folder.
The shortcuts include:
Source, Target, Tranformation, Mapping, Mapplet,Reusable
Transformation, Business Components.
| Is This Answer Correct ? | 3 Yes | 0 No |
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
why union transformation is active transformation?
Design a mapping to get year of join for each employee.
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what is the difference between stop and abort
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
without update strategy how to insert &update?
Define error Threshold?
how do u tune queries?
how many types transformations supported by sortedinput?
Teradata 
