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

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

What is xml source qualifier transformation in informatica?

0 Answers  

---