i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 2

i have source like
X1 10
X2 20
X1 30
X2 40

i want target as
X1 X2
10 20
30 40 in informatica

Question Posted / ajit_nitr

2 Answers
7389 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informat..

Answer / raji

Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...

Is This Answer Correct ?

2 Yes

0 No

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informat..

Answer / sushma

SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET

In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,

In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)

In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table

Is This Answer Correct ?

4 Yes

3 No

Post New Answer