Answer Posted / babu

Hi Sbvprasad,
Your answer has small correction,

V1=iif(not isnull (id),id,v1)

for the 1st record.
V1= iif( not isnull (101), then pass 101).
now the V1 variable having the value = 101.

2nd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

3rd record
V1= iif( not isnull ( null), then pass else condition V1 (
having 101 ))
now the V1 variable having the value = 101.

After applied the above logic we will get the output as
mentioned below.
-------------
ID NAME
--- ------
101 PANKAJ
101 KUMAR
101 MATHUR
102 JYOTI
102 SAXENA
103 SACHIN
102 TENDULKAR

2.Take an EXP t/r,in this t/r declare two variable ports
for ID and Name columns.those are PRV_ID and VAR_NAME

VAR_NAME=IIF(PRV_ID=ID,VAR_NAME||' '||NAME,NAME)
PRV_ID=ID
OP_NAME=VAR_NAME (OUTPUT PORT)

3.In the next step take the aggregator transformation and
group by on the ID COLUMN. Then you will get the result.

TARGET TABLE
-------------
ID NAME
--- -------
101 PANKAJ KUMAR MATHUR
102 JYOTI SAXENA
103 SACHIN TENDULKAR

MAPPING ::
---------

SRC-->SQ-->EXP-->EXP-->AGGR-->TRG
IF ANY THING WRONG, PLEASE CORRECT WITH PROPER SOLUTION.

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2347

---

Explain pmcmd command usage in informatica

1140

---

What is mapping debugger?

1022

---

what is unit testing?tell me proceedure

2229

---

Plz can any one say me how to get the informatica certification materials and dumps

2051

---

Tell me about Propagate functions in informatica

927

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2071

---

Explain in detail about scd type 1 through mapping.

1559

---

What is native users?

1174

---

Explain load alternative records / rows into multiple targets - informatica

1160

---

Can we create two repositories on same database instance in oracle?

1103

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191

---

list out all the transformations which use cache?

1190

---

How to start a workflow using pmcmd command?

1257

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1171

---