Join within Mapping

[kpmINFO]

If I have data comming from same source and split into two, can I join the two streams into one , if yes How can I join them.

Here is a small example

Transformation 1
col1 col2 col3
a b c

Transformation 2
col1 col2
c1 c2
c3 c4
c5 c6

can I get something like this in
Transformation 3
col1 col2 col3
c1 c2 a
c3 c4 a
c5 c6 a

Can I achieve this, if yes how
Not to forget both Transformation 1 and transformation 2 are comming form same source.
Can I use Normalizer tr for this? if yes how, if not what is the best way????
(Informatica 6.2)

 

[blom0344]

No ,you cannot first split data from a SQ, manipulate the streams and then re-join them. Use 2 SQ's with appropriate filters and you'll get what you want....

T. Blom
Information analyst
tbl@shimano-eu.com