Answer Posted / raj
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 ? | 6 Yes | 0 No |
Post New Answer View All Answers
design of staging area?
What if the source is a flat-file?
How to load the data from people soft hrm to people soft erm using informatica?
Design a mapping to load a target table with the following values from the above source?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are mapplets? How is it different from a Reusable Transformation?
Separate from a database, an information bazaar, and an information stockroom?
What is confirmed fact in dataware housing?
Clarify the aggregator change?
lookup transformation with screenshots
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is xml source qualifier transformation in informatica?
What is informatica?
While migrating the data from one environment to another environment how would you manage the connections?
tell me the rules and responsblites in our project(my project is development)