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

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2103

---

what are the Methods For Creating Reusable Transformations?

1153

---

How big was your fact table

1784

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2141

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1067

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

990

---

Quickly characterize reusable change?

1091

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1237

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1152

---

What are the differences between oltp and olap?

959

---

Explain direct and indirect flat file loading (source file type) - informatica

1303

---

In which transformation you cannot drag ports into it?

1296

---

What are the mapping parameters and mapping variables?

1153

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1145

---

What do you mean incremental aggregation?

1052

---