Answer Posted / zer0

Create the mapping as below:

EXP1 ---> SRT1
/ \
Src --> Router Joiner ---> EXP3 ---> Targ
\ /
EXP2 ---> SRT2

Router: Filter on the basis of gender. All records with
gender male wil go into EXP1 and the records with gender
female will go into EXP2.
In EXP1 and EXP2, create a variable dummy port (Seq_Var)
with value Seq_Var+1 and an output port Seq_Out (value-
Seq_Var).
Pass the name and sequence ports from EXP1 and EXP2 to SRT1
and SRT2 (sorter) respectively.
In SRT1 and SRT2, sort on the basis of sequence.
In Joiner, use 'Full Outer Join' and keep 'Sorted Input'
checked in properties.
Pass the male name values and female name values from
joiner to EXP3 (Gather all the data). Pass all the data to
Target.

What does update strategy mean, and what are the different option of it?

1140

---

r u done any partitions in ur project?

1863

---

What is complex mapping?

1171

---

What is the difference between informatica 7.0 and 8.0?

1052

---

explain abt ur project architecture?

2233

---

What can we do to improve the performance of informatica aggregator transformation?

1142

---

How to create Target definition for flat files?

1283

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1145

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1169

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1917

---

What is the surrogate key?

1362

---

What is repository manager?

1026

---

Is there any target staging area in informatica not staging area

2631

---

What is update strategy transform?

1163

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1305

---