Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7867 Views
- I also Faced
- E-Mail Answers
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 different types of repositories created using informatica?
What are the differences between oltp and olap?
How to load last n records of file into target table - informatica
What is Session and Batches?
While migrating the data from one environment to another environment how would you manage the connections?
difference between informatica 8.1.1 and 8.6
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between informatics 7x and 8x and what is latest version?
Informatica Checkpoints
What is rank index in rank transformation?
What happens when a session fails and you click on recover?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is meant by active and passive transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is intricate mapping?
