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
- 8079 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
Explain lookup transformation source types in informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Differentiate between source qualifier and filter transformation?
How many number of sessions can one group in batches?
What is meant by query override?
Explain how many types of dimensions are available in informatica?
What is the advantage of informatica?
what is song in infrmatica...?
How to load the data from people soft hrm to people soft erm using informatica?
How to elaborate tracing level?
On which transformations you created partitions in your project?
What is meant by pre and post session shell command?
Please let me know how to make encryption and decryption with example?
Define joiner transformation?
What is rank transformation in informatica
