difference between shortcut and 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 ? | 9 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is standalone command task?
Is stop and abort are same in informatica?
can anyone explain me about retail domain project in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is informatica metadata?
What are the components of the workflow manager?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is confirmed fact in dataware housing?
Which version configuration tool used in ur project?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What does cheating measurement mean?
What are the advantages of informatica?
What is a predefined event?