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 is difference between a connected look up and unconnected look up?
What is use of batch file in informatica? How many types of batch file in informatica?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
What are the session parameters?
what is the difference between Informatica 7.1 and Abinitio?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
what is materialized view?
comonly how meny mappings r there in Banking projects?
if i have a delimited file as source so how can we seperate this file into three diff targets?