Answer Posted / 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 clients of powercenter?

1073

---

Explain how many types of dimensions are available in informatica?

1111

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2756

---

In informatics server which files are created during the session rums?

1129

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1182

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2047

---

What are junk dimensions?

1080

---

Explain the scenario which compels informatica server to reject files?

1174

---

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

1739

---

What is union transformation in informatica?

1154

---

server hot-ws270 is connect to Repository B. What does it mean?

2576

---

How are the sources and targets definitions imported in informatica designer?

1116

---

Which development components of informatica have the highest usage?

1068

---

What is the maplet?

1132

---

How to extract sap data using informatica?

1052

---