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
- 8022 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 many input parameters can exist in an unconnected lookup?
What do you mean by blocking transformation?
Where is metadata stored?
What is primary and backup node?
Under which circumstances, informatica server creates reject files?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
expain about the tune parameters?
Why update strategy and union transformations are active? Explain with examples.
What is DR strategy for Informatica project?
How do you load only null records into target? Explain through mapping flow.
What are the tuning techniques you applied during your last project
What is the Rank index port in Rank transformation?
What is data transformation manager process?
In which transformation you cannot drag ports into it?
Explain the different kinds of facts.
