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
Clarify the utilization of aggregator cache record?
Explain the different dimensions.
What are the static cache and dynamic cache in informatica?
What is joiner transformation in informatica?
what are the Methods For Creating Reusable Transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
pmscmd startworkflow -sv
How do you convert single row from source into three rows into target?
What is sq transformation?
can u give example for factless fact table
How to open an older version of an object in the workspace?
How to implement security measures using repository manager?
Define enterprise data warehousing?
Explain what transformation and how many are there in informatica?
What are data-driven sessions?