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

What is a repository? And how to add it in an informatica client?

1193

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1019

---

How can you validate all mappings in the repository simultaneously?

1424

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150

---

What is the need of an ETL tool?

1157

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5789

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2184

---

How are the sources and targets definitions imported in informatica designer?

1170

---

What is repository manager?

1026

---

How to go to the older version for a mapping?

1156

---

Where is metadata stored?

1192

---

What is the sql query overwrite in source qualifier in informatica

1142

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577

---

What is the Rank index port in Rank transformation?

1102

---

What is workflow? What are the components of workflow manager?

1232

---