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 are the prerequisite tasks to achieve the session partition?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is informatica? Why do we need it?
What if the source is a flat-file?
Why filter transformation is an active one?
Which means the first record should come as last record and last record should come as first record and load into the target file?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the use of code page?
Enterprise data warehouse your projects phase by phase explain?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is Index Caches size?
how to load rows into fact table in data warehouse
Global and Local shortcuts. Advantages.
What is a dimensional model?