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
- 8248 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
How you can differentiate between connected lookup and unconnected lookup?
what are the deliverables?in your project?
Explain informatica architecture - version 8 / 9
What is a filter transformation and why it is an active one?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Briefly explain the aggregator transformation?
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
What is the difference between a repository server and a powerhouse?
explain abt ur project architecture?
What are the different types of repositories created using informatica?
What are the main features of Oracle 8i with context to datawarehouse?
How to implement security measures using repository manager?
How to join three sources using joiner?
Explain how many types of dimensions are available in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
