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

generate date / time dimension in informatica

715

Define the various join types of joiner transformation?

557

What is the cumulative sum and moving sum?

752

what is song in infrmatica...?

1668

what is diff b/t sorter t/r and agg have the option sorter property...

1737

What are the different types of olap? Give an example?

554

Under what condition selecting sorted input in aggregator may fail the session?

655

How an expression transformation differs from aggregator transformation?

622

server hot-ws270 is connect to Repository B. What does it mean?

1848

Explain pushdown optimization $pushdownconfig parameter - informatica

695

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

767

What is the fact table?

584

Which are the different editions of informatica powercenter that are available?

553

update strategy transformation in informatica

636

What are connected or unconnected transformations?

622