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
- 6686 Views
- I also Faced
- E-Mail Answers
Answer Posted / bebo
use comma delimiter..infa will identify the null values
while importing the flat file
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
Differentiate between joiner and lookup transformation?
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 ?
What are the main issues while working with flat files as source and as targets ?
Differentiate between source qualifier and filter transformation?
What are the performance considerations when working with aggregator transformation?
what is the difference between informatica6.1 and infomatica7.1
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What all join we can perform in LOOKUP transformation?
What differs when we choose the sorted input for aggregator transformation?
update strategy transformation in informatica
design of staging area?
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 way to execute pl/sql script using informatica mapping?
can u give example for factless fact table
