Diff b/w ShortCut and reusabel Object ?
Answers were Sorted based on User's Feedback
Hi, REKHA
Can u check your answer ! Thanks for Posting.
""" 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"""""
If any Corrections Let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / 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 |
Answer / srini
Shortcut object will be used in across different folder
where as reusable will be valid in with in folder
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / rekha
U CAN USE SHOTCUTS WITH IN THE MAPPING WHERE AS REUSABLE
OBJECTS U CAN USE ACROSS MAPPINGS OF THE EPOSITORY
| Is This Answer Correct ? | 0 Yes | 12 No |
Global and Local shortcuts. Advantages.
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Can you start a batches with in a batch?
What is data merging, data cleansing and sampling?
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.
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
what is distinct
what is the difference between static and dynamic
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500