I have a file with data comming as
1,x1,x2,x3
2,a1,a2
3,b1,b2,b3,b4
1,y1,y2,y3
2,c1,c2,c3
3,d1,d2
my out put should be as follows
x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4
y1,y2,y3,c1,c2,c3,d1,d2,<null>
Please let me know how can we acheive this in informatica
Thanks in advance
Answer Posted / rahul
use an exp t/r,
take an variable port as count = 0
keep inc the count by 1 and place a conditin if count > 4 ,
than set count = 0
and in other variable port ypu concate the columns value.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the commit type if you have a transaction control transformation in the mapping?
What does command task mean?
What is a node in Informatica?
Informatica Checkpoints
Which development components of informatica have the highest usage?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to improve the performance of a session using sorter transformation?
What is different between the data warehouse and data mart?
What is blocking transformation?
What do mean by local and global repository?
Explain about Informatica server process that how it works relates to mapping variables?
What is powercenter on grid?
What are multi-group transformations?
Explain the code page compatibility?
How to start a workflow using pmcmd command?