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.

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

what is polling?

1 Answers   Informatica,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

What is surrogate key?

9 Answers  

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---