Interested to Buy Any Domain ? << Click Here >> for more details...
difference between shortcut and reusable transformation?
- 2 Answers
- 10120 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 9 Yes | 0 No |
Answer / krithi
Shortcuts allow you to share multiple objects within the
repository i.e., we can use an object in the shared folder
without creating or copying. If the original object
changes, the shortcuts reflects the changes.
Whereas a Reusable Transformation can be used only within
the mappings in that folder.
The shortcuts include:
Source, Target, Tranformation, Mapping, Mapplet,Reusable
Transformation, Business Components.
| Is This Answer Correct ? | 3 Yes | 0 No |
In a sequential batch can you run the session if previous session fails?
without dynamic lookup how to insert new rows and update existing rows?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is sequence generator transformation in informatica?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
what is the purpose of surrogate key and diff between primary key&surrogate key
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to load last 10 records of flat file in to the target?
Mapplets can you use an active transformation in a mapplet,
In a sequential batch can u run the session if previous session fails?
Teradata 
