Answer Posted / siva

Take the mapping as (suppose the columns as C1, c2)
SD --> SQ --> Exp --> Agg --> Tgt
In exp define as
c1 <-- c1
c2 <-- c2
v_2 <-- IIF(c1 = v_1,TO_CHAR(v_2) || ', ' || TO_CHAR
(c2),TO_CHAR(c2))
v_1 <-- c1
o_p1 <-- v_2
In Agg
Group by c1
c2 <-- v_2
c11 <-- LAST(c1)
Tgt is connected as
c1 <-- c11
c2 <-- c2

v_ stands for variable port and o_ stands for output port

I think it can be understood by you

Thanks for your response

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1022

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1429

---

how to create user defined function (udf) in informatica

1243

---

How we can create indexes after completing the load process?

1108

---

Explain Dataware house architecture .how data flow from intial to end?

2526

---

What do mean by local and global repository?

1151

---

can anyone explain me about retail domain project in informatica?

7890

---

update strategy transformation in informatica

1014

---

what is index?how it can work in informatica

1980

---

where to store informatica rejected data?

1046

---

What is the sequence generator transformation in informatica?

1093

---

What are junk dimensions?

1020

---

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

1041

---

What is an unconnected transformation?

1033

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1024

---