Interested to Buy Any Domain ? << Click Here >> for more details...
difference between shortcut and reusable transformation?
- 2 Answers
- 10007 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 |
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
What are the different versions of informatica?
How can you complete unrcoverable sessions?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
How to generate the HTML output using Informatica.
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What is a mapplet/worklet in informatica?
what is mean by grouping of condition column in lookup transformation?
Differentiate between joiner and lookup transformation?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What are the issues you have faced in your project? How did you overcome those issues?
Can we create a Integration service without a Repository service and vice versa?
Teradata 
