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

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

What are two types of processes that informatica runs the session?

2 Answers  

---

Why we use stored procedure transformation?

4 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

what is the difference between lookupoveride and joiner?

3 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

How to elaborate tracing level?

0 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---