S-->SQ-->EXP-->AGG--->TGT EXP: Create Variable port: res:

my source has 2 columns. 1st column data: ABC ABC ABC XYZ
and 2nd column data: 1 2 3 4. And my target should be ABC 1 2
3, XYZ 4

Question Posted / moorthy g

Answer Posted / moorthy g

S-->SQ-->EXP-->AGG--->TGT
EXP:
Create Variable port:

res: decode(col1=prev_col1,concat(res,col2), col2)
O_put: res
pre_col1=col1

AGG:
group by col1

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to extract the informatica rejected data?

753

what are the Methods For Creating Reusable Transformations?

649

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640

difference between repository database and repository service?

622

Why update strategy and union transformations are active?

592

What do you mean by enterprise data warehousing?

644

Explain informatica architecture - version 8 / 9

669

What is a sequence generator transformation?

577

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

632

Whats there in global repository

1268

How can you increase the performance in joiner transformation?

710

Is there any target staging area in informatica not staging area

2126

Can we create multiple integration service on single repository?

700

How many types of sessions are there in informatica.please explain them?

678

What is lookup change?

617