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 |
What is the Difference between DSS & OLTP?
How do you recover rows from a failed session
Is there any model difference between ODS and DWH
how do the project develops? pls specify right from the start to end in step by steps.
can anyone suggest best free Talend data integration training online
when will we go for unconnected lookup transformation in Informatica?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
How will the document be delivered to me?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What is the query to find nth highest salary? What is the use of cursors?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?