Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
- 1 Answers
- 4995 Views
- I also Faced
- E-Mail Answers
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 |
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
What are the different versions of informatica?
How do you implement scheduling in Informatica?
what is the -ve test case in your project.
What is a standalone command task?
How to generate sequence numbers?
Define pmcmd command?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
wht is cdc?how to use it in creation of mappings?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Teradata 
