How to convert column data into row data in Informatica without using the normalizer transformation?

The scenario is described below-
The source data looks like
col1, col2, col3
a, b, c
d, e, f
The target table data should look like
Col
a
b
c
d
e
f
#informatica #informaticascenarios #informaticainterviews

[@RiteshGatpalli]

Cant we use sorter after the union to sort the data alphabetically ?

[@lohithasetty8956]

We have given sequence as sequence+1 in exp transformation but we didn't define any initial value as sequence =0 to add with 1... Can you explain that ?

[@viveksingh-oh8xi]

Can we replace first expression you have taken for sequence with sequence generator??

[@TechTutorETLandAWS]

Behavior of seq. generator is different. It processes each block of data pipeline at once. So all 3 expressions will not have have same sequence. Check Informatica help on Seq generator you will understand

[@PoojaSingh-xq6kk]

What if we have 100 columns then 100 expression we will add

[@TechTutorETLandAWS]

Pass it through one expression in that case. All columns of SQ ---> exp

[@viveksingh-oh8xi]

@@TechTutorETLandAWS I have keen to know the answer. Could you please elaborate ?

[@keerhiful]

What if we have 20columns, we cant use 20expression transformation Anyother method

[@TechTutorETLandAWS]

Then you have to pivot data using Normalizer.