1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Source table
-------------
ID NAME
--- ------
101 PANKAJ
NULL KUMAR
NULL MATHUR
102 JYOTI
NULL SAXENA
103 SACHIN
NULL TENDULKAR


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


How to do the above scenario in Informatica.

Question Posted / babu

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.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

574

Under what conditions selecting sorted input in aggregator will still not boost session performance?

625

What is flashback table ? Advance thanks

1476

Can u generate reports in Informatica?

649

Is it possible to create multiple domains on a single Informatica server?

747




What is repository manager?

529

 Informatica Checkpoints

2848

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

616

whats the logic to load the lower level of granularity of data to fact table.

1789

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

597

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1841

What is a sequence generator transformation?

566

What is joiner change?

665

What is meant by a domain?

619

Define mapplet?

622