What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly define a session task?

599


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1569


What are the static cache and dynamic cache in informatica?

729


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

559


what is the size of u r source(like file or table)?

1829






What do you mean by channel change?

558


Implementation methodology

1270


How will the document be delivered to me?

627


What are the differences between source qualifier and joiner transformation?

606


How might you approve all mappings in the archive all the while?

613


What is an unconnected transformation?

674


What is meant by a domain?

640


Explain joiner transformation in informatica

675


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1520


What is primary and backup node?

711