Answer Posted / babu

Hi Aruna,

U r answer has small change,i.e one output port and in
aggregator t/r column1 is group by port not column2.

SRC
|
SQ
|
EXP
{
(variable port) var:IIF(col1=var1,concat(var,col2),col2)
(variable port) var1:(col1)
(output port) oup:var
}
|
AGGR(COL1 AS A GROUP BY PORT)
|
TRG

MAPPING DESIGN::

SRC-->SQ-->EXP-->AGGR-->TRG

How to delete duplicate row using informatica?

1087

---

What are data-driven sessions?

1259

---

What is the reusable transformation?

1100

---

which one is better performance wise joiner or look up

1149

---

How can we handle two sessions in informatica?

1092

---

COM components can be used in Informatica

2451

---

How to differentiate between the active and passive transformations?

1229

---

Mention a few design and development best practices for informatica?

1043

---

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?

1817

---

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

1165

---

Explain why we use partitioning the session in informatica?

1162

---

Write the program through which the records can be updated?

1053

---

What is the commit type if you have a transaction control transformation in the mapping?

1096

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2126

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2086

---