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
- 8008 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
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How big was your fact table
What is a router transformation?
What the difference is between a database, a data warehouse and a data mart?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is joiner change?
What are the types of presistent cache in look up tr.
What is the different lookup cache(s)?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the sql query overwrite in source qualifier in informatica
What is lookup transformation?
How to open an older version of an object in the workspace?
What is option by which we can run all the sessions in a batch simultaneously?
