Answer / bhageerath

src->sq->exp->aggr->tgt

src(col1[int],col2[varchar])

sq(col1[int],col2[varchar])

exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}

imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}

aggr(col1,o_col2)

tgt(col1,col2)

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

---

How do you recover rows from a failed session

1 Answers  

---

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

0 Answers  

---

What are mapplets?

0 Answers  

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---