What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
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 |
What are the rank caches?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can yoU create or import flat file definition in to the warehouse designer?
What is hash partition?
Major difference between SQL override and Lookup Sql override
What are the modules in Power Center
How many repositories can we create in Informatica?
What is repository manager?
what is target update override and when we use it?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What is xml source qualifier transformation in informatica?