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 implement security measures using repository manager?

1243

Define pmcmd command?

1105

Explain the types of transformations?

1101

How to extract sap data using informatica?

1094

What is aggregator transformation in informatica?

1004

Differentiate between Load Manager and DTM?

2213

How do you load unique records into one target table and duplicate records into a different target table?

1316

What is pmcmd command?

1181

expain about the tune parameters?

2457

How to handle decimal places while importing a flatfile into informatica?

1240

Define update strategy?

1315

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1916

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

Can we create a Integration service without a Repository service and vice versa?

1257