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
- 6712 Views
- I also Faced
- E-Mail Answers
Answer Posted / pandu
u can use sq transformation .
start value 1,
incremental value 1,
reset value:slect,
and use the rank transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
What is informatica powercenter repository?
What do you mean by enterprise data warehousing?
What are the types of data warehouses?
Why union transformation is an active transformation?
explain abt ur project architecture?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Whats the difference between informatica powercenter server, repositoryserver and repository?
design of staging area?
What is blocking transformation?
What is data transformation manager process?
What are the different options available for update strategy?
What do mean by local and global repository?
How can you validate all mappings in the repository simultaneously?
Where are the source flat files kept before running the session?
