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
- 7868 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 InformaticaPowerCenter?
what is the complex transformation you used in informatica
Briefly explain the aggregator transformation?
What is standalone command task?
What is the way to execute pl/sql script using informatica mapping?
what is the hint? how to use it to reduce the query processing in program?
In informatica workflow manager, how many repositories can be created?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Differentiate between reusable transformation and mapplet.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How does a sorter cache works?
Explain scd type 3 through mapping.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Write the different tools in the workflow manager?
