difference between shortcut and reusable transformation?
Answers were Sorted based on User's Feedback
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 ? | 9 Yes | 0 No |
Answer / krithi
Shortcuts allow you to share multiple objects within the
repository i.e., we can use an object in the shared folder
without creating or copying. If the original object
changes, the shortcuts reflects the changes.
Whereas a Reusable Transformation can be used only within
the mappings in that folder.
The shortcuts include:
Source, Target, Tranformation, Mapping, Mapplet,Reusable
Transformation, Business Components.
Is This Answer Correct ? | 3 Yes | 0 No |
Define mapping and session?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you use reject loader.
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?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What you know about transaction control transformation?
Which is costliest transformation? costly means occupying more memory?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
What are active transformations.