Answer Posted / s

INPUT
col1 col2
101 1000
101 1500
101 2000
102 1200
102 2300
102 3000
103 2400
103 1300
103 2000

OUTPUT
col1 col2
101 1000,1500,2000
102 1200,2300,3000
103 2400,1300,2000


SOURCE->SRT->EXP->TGT

SRT - Sort by column col1.
EXP - col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_col1=col1
o_col1=v_col1
o_col2=v_col2

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

2468

---

Can we get 1st record through Informatica(without sequence number).

1401

---

How many types of sessions are there in informatica.please explain them?

1110

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1014

---

Explain the tuning lookup transformation - informatica

950

---

Clarify the utilization of aggregator cache record?

942

---

How to load last n records of file into target table - informatica

1018

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2020

---

What is lookup change?

983

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1196

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2676

---

How to generate sequence numbers using expression transformation?

1025

---

How might you approve all mappings in the archive all the while?

955

---

What are the new features of informatica 9.x at the developer level?

983

---

What are the features of complex mapping?

1093

---