Answer Posted / 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.

What will be the approach?

963

---

design of staging area?

2016

---

How do you convert single row from source into three rows into target?

1137

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1025

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1137

---

is it possible to index the data in cache of lkp transformation ?

2018

---

What are the static cache and dynamic cache in informatica?

1171

---

What is InformaticaPowerCenter?

1113

---

What is the need for an etl tool?

1054

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1887

---

What is joiner transformation?

984

---

What is DR strategy for Informatica project?

1157

---

What are the advantages of using informatica as an etl tool over teradata?

1008

---

What is depict expression change?

1089

---

explain about unit testing? in real time?

2181

---