What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
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 ? | 4 Yes | 1 No |
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Define Update Override?
Without using Lookup & Sequence Generator, How to generate Sequence?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What is the target load order?
without table how to come first record only in oracle?
If I have a index defined on target table and if set it to bulk load will it work ?
Is stop and abort are same in informatica?
which transformation uses cache?
What is the use of code page?
Different circumstance which drives informatica server to expel records?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?