Answer / sreepathi

Well make the (id, attachment) as unique or primary key
instead of id being primary key. Hope this solves you
problem, if not come out with clear requirement.

Answer / zer0

As far a i understood ur scenario u need each attachment
with its ID and name.

For this you can have a simple mapping made in Informatica.

SQ ----> Expression ----> Target

In Expression create the following:

Input/Output Port: ID
Input/Output Port: Name
Variable Port: Attachments_var1 ---> CHR(32) || TO_CHAR(ID)
|| CHR(9) || Name || CHR(9)
Variable Port: Attachments_var2 ----> REPLACESTR
(0,Attachments,CHR(32),CHR(10) || Attachments_var1)
Output Port: Attachments_out -----> REPLACECHR
(0,Attachments_var2,CHR(32),'')

From expression output the fields to target (Flat File),
you might get your answer

Note: the first record has a space in the attachment name,
that needs to be looked into

how to join two flat files in informatica?

3 Answers   Wipro,

---

What is A complex mapping?

3 Answers   TCS,

---

What is the surrogate key?

0 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

What are the features of complex mapping?

0 Answers  

---

Write the program through which the records can be updated?

0 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

All active transformations r passive or not?

7 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---