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 |
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Could any one to tell Fact table Partitioning?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
How can we remove the duplicates from flat file source?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
plz plz plz send client names and project names in informatica?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
how to get the first row without using rank t/r?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
What are the new features of informatica 7.1?
how you will maintain version?
Difference Between ETL & ELT?