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 |
in oracle write query yourname+1 from dual
How are the sources and targets definitions imported in informatica designer?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
tell me 5 session failure in real time how can you solve that in your project?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
what is the diff b/w cached and unchaed look ups
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Explain the different kinds of facts.
What is hash partition?
Where is metadata stored?
how do u use sequence created in oracle in informatica? Explain with an simple example