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
- 8087 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
Explain the features of connected and unconnected lookup.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is meant by lookup transformation? Explain the types of lookup transformation?
Write the program through which the records can be updated?
How to join three sources using joiner? Explain though mapping flow.
What are multi-group transformations?
How to elaborate tracing level?
Please let me know how to make encryption and decryption with example?
What is source qualifier transformation in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Enlist the various types of transformations.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Tell me about Propagate functions in informatica
Can we override a native sql query within informatica?
Name the different lookup cache(s)?
