Is there any way we can do the column to row transformation through informatica? The reverse (row --> column) conversion is possible thru normalization transformation.
NOTE : [I][This question was asked by geetham] [/I]
Printable View
Is there any way we can do the column to row transformation through informatica? The reverse (row --> column) conversion is possible thru normalization transformation.
NOTE : [I][This question was asked by geetham] [/I]
Hi
If it occurs only twice , then we can use an aggregator and group by the repeating group and use first() and last() function.
Does this help?
Hi,
Column to Row - Normalizer Transformatin
Row to Column - Using an Expression and Aggregatoru can achieve that task.
Please get back to us in case of queries.
Thx
Prakash:)
hi ,can any one pls explain it clearly?
Thanks in advance.