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
What are the modules in Power Center
Is stop and abort are same in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain the code page compatibility?
Clarify the aggregator change?
What is meant by pre and post session shell command?
Explain the aggregator transformation?
Separate from an archive server and a powerhouse?
What is a joiner transformation?
How to create the source and target database connections in server manager?
how tokens will generate?
Mention few power centre client applications with their basic purpose?
write a query to retrieve the latest records from the table sorted by version(scd)
How would you copy the content of one repository to another repository?
What is rank index in rank transformation?