Answer Posted / venky

src->sorter->exp->agg->tgt

sorter:-

select col1 key as sorter

exp:-

var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output_port=var1

agg;-

select group by col1

tgt:-

connect to target

How to convert multiple rows to single row (multiple columns) in informatica

1376

---

Partition, what happens if the specified key range is shorter and longer

2487

---

Explain the scenario which compels informatica server to reject files?

1160

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1103

---

How can we update a record in the target table without using update strategy?

1136

---

Please let me know how to make encryption and decryption with example?

1896

---

Can we create a Integration service without a Repository service and vice versa?

1213

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7223

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1127

---

expain about the tune parameters?

2409

---

Explain the code page compatibility?

1057

---

Sequence generator, when you move from develoment to production how will you reset

2028

---

Describe data concatenation?

1072

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2129

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

---