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)

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

---

How do you take back up of repository?

0 Answers  

---

how tokens will generate?

0 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

where is the reject loader .

1 Answers  

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---