Answer Posted / 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 the use of code page?

1085

---

Can we get 1st record through Informatica(without sequence number).

1476

---

Please let me know how to make Data masking in informatica..

1711

---

Is stop and abort are same in informatica?

995

---

What is the way to execute pl/sql script using informatica mapping?

1598

---

Explain transaction control transformation in informatica

1263

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1320

---

what is the complex transformation you used in informatica

2585

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1761

---

How to Create a folder using pmrep command?

1173

---

Mention a few design and development best practices for informatica?

994

---

Write the prerequisite tasks to achieve the session partition?

1149

---

Which transformation should we use to normalise the COBOL and relational sources?

1199

---

Describe an informatica powercenter?

1124

---

How we can create indexes after completing the load process?

1156

---