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
- 8095 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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a repository? And how to add it in an informatica client?
What is informatica worklet?
What is joiner transformation?
Describe an informatica powercenter?
What are the new features of Power Center 5.0?
What is the difference between Active and Passive transformation?
Explain pushdown optimization and types in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How do you migrate data from one environment to another?
While migrating the data from one environment to another environment how would you manage the connections?
What are ETL Tools?
How to open an older version of an object in the workspace?
How to elaborate tracing level?
Different sorts of metadata that stores in the storage facility?
