Interested to Buy Any Domain ? << Click Here >> for more details...
difference between shortcut and reusable transformation?
- 2 Answers
- 10066 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 |
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
What is the difference between Power Centre and Power Mart?
What are the main issues while working with flat files as source and as targets ?
how can import the data from the flat files?
What is the benefit of partitioning a session?
How an expression transformation differs from aggregator transformation?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
How to delete duplicate records in a flat file source?
What is hash partition?
Is it possible to update the target table with PK?
What is data merging, data cleansing and sampling?
Teradata 
