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
- 8254 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 is deployment group?
Informatica settings are available in which file?
What happens when a session fails and you click on recover?
What are active and passive transformations?
What is the meaning of up gradation of repository?
When do you use sql override in a lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain about cumulative Sum or moving sum?
EXL informatica Questions
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a connected transformation?
What is the fact table?
Which are the different editions of informatica powercenter that are available?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
