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.

Answer / krithi

Shortcuts allow you to share multiple objects within the
repository i.e., we can use an object in the shared folder
without creating or copying. If the original object
changes, the shortcuts reflects the changes.

Whereas a Reusable Transformation can be used only within
the mappings in that folder.

The shortcuts include:

Source, Target, Tranformation, Mapping, Mapplet,Reusable
Transformation, Business Components.

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---