Answer / srinivas

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Answer / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

why we need informatica

2 Answers   HCL,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

What is an expression transformation?

0 Answers  

---

How can we delete duplicate rows from flat files?

0 Answers  

---

How do you take back up of repository?

0 Answers  

---

What is difference macros and prompts?

2 Answers  

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---