What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
Answer Posted / 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 ? | 4 Yes | 1 No |
Post New Answer View All Answers
COM components can be used in Informatica
Target increases every day even though no new record was inserted
What differs when we choose the sorted input for aggregator transformation?
Performance tuning( what you did in performance tuning)
What is pmcmd command?
How do you handle two sessions in Informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Is there any way to read the ms excel datas directly into informatica?
How do you change a non-reusable transformation to reusable transformation?
What all are steps in up gradation of Informatica server?
What are the types of caches in lookup?
Global and Local shortcuts. Advantages.
What are the guidelines to be followed while using union transformation?
What is target designer and target load order?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures