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

2 Answers
7134 Views
Zensar, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a joiner transformation?

993

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1263

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2181

What do you mean by enterprise data warehousing?

1063

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1672

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1123

What is workflow monitor?

1058

How to join three sources using joiner?

1105

What is standalone command task?

1314

Sequence generator, when you move from develoment to production how will you reset

2034

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

What are the data movement modes in informatica?

1150

Describe an informatica powercenter?

1125

Can we create multiple integration service on single repository?

1187

What is data transformation manager process?

1151