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)

Why union transformation is an active transformation?

1102

---

How to delete duplicate row using informatica?

1090

---

What the difference is between a database, a data warehouse and a data mart?

1202

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1142

---

what is INFORMATICA TESTING process

2334

---

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 ?

2246

---

Which are the different editions of informatica powercenter that are available?

1082

---

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

1137

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2259

---

What is informatica etl tool?

1061

---

Explain pushdown optimization and types in informatica

1122

---

Explain sessions and how many types of sessions are there?

1060

---

What is meant by active and passive transformation?

1194

---

Explain about Informatica server process that how it works relates to mapping variables?

1128

---

What is status code in informatica?

1065

---