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



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

Post New Answer

More Informatica Interview Questions

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,


Define Update Override?

1 Answers  


Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


What is the target load order?

3 Answers   HCL, Informatica,






without table how to come first record only in oracle?

0 Answers  


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


Is stop and abort are same in informatica?

0 Answers  


which transformation uses cache?

3 Answers   Keane India Ltd,


What is the use of code page?

0 Answers  


Different circumstance which drives informatica server to expel records?

0 Answers  


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


Categories