What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
- 1 Answers
- 5261 Views
- I also Faced
- E-Mail Answers
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 |
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
How do you do error handling in Informatica?
what is the difference between stop and abort
Name the different lookup cache(s)?
How to update or delete the rows in a target, which do not have key fields?
What is the different lookup cache(s)?
What is xml source qualifier transformation in informatica?
What do think which one is the better joiner or look up?
Can we have a Mapping without a Source Qualifier?
What are the reusable transforamtions?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Teradata 
