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

what is INFORMATICA TESTING process

2297

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

---

Mention few advantages of router transformation over filter transformation.

1023

---

what is informatica metadata?

1043

---

how to create user defined function (udf) in informatica

1313

---

What is the difference between Active and Passive transformation?

1153

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1955

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2306

---

How to create Target definition for flat files?

1228

---

What is sequence generator transformation in informatica?

1081

---

Reusable transformation and shortcut differences

1842

---

What is the benefit of session partitioning?

1116

---

What is confirmed fact in dataware housing?

6974

---

How identifying bottlenecks in various components of informatica and resolving them?

1135

---

Informatica settings are available in which file?

992

---