Answer / 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

Answer / hanan

src->exp->agg->tgt

src:-

In sql query write order by col1

exp:-

col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2

agg;-

select group by col1

tgt:-

connect to target

What is a poling?

2 Answers  

---

Can you use flat files in Mapplets.

0 Answers  

---

What is active and passive transformation?

10 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

What does reusable transformation mean?

0 Answers  

---

How to load a relational source into file taget?

2 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

what is distinct

4 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

explain abt joiner t/r?

1 Answers   IBM,

---