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 Session and Batches?
How can we delete duplicate rows from flat files?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
How to get EVEN & ODD numbers separately?
If we set dd_insert in mapping and Delete in session properties what will happen.?
what is dynamic cashe
What is the Difference between PowerPlay transformer and power play reports?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
how remove 1st 3 records & last 3 records in informatics
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.