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 do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1056

---

What is meant by LDAP users?

1107

---

What is the difference between router and filter?

1148

---

How union transformation is used?

952

---

What is substr in informatica?

1131

---

what is unit testing?tell me proceedure

2163

---

What is the advantage of informatica?

1012

---

How many input parameters can exist in an unconnected lookup?

1489

---

What are the features of complex mapping?

1091

---

What is the difference between informatica 7.0 and 8.0?

951

---

What are the performance considerations when working with aggregator transformation?

1094

---

difference between informatica 8.1.1 and 8.6

3624

---

How to load last n records of file into target table - informatica

1018

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

997

---

What are the static cache and dynamic cache in informatica?

1137

---