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
- 8246 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
What is source qualifier transformation in informatica?
How big was your fact table
Explain direct and indirect flat file loading (source file type) - informatica
Different sorts of metadata that stores in the storage facility?
Explain the difference between mapping parameter and mapping variable?
What do you understand by SOA of Informatica?
what is $$$$?
What is the commit type if you have a transaction control transformation in the mapping?
Can we get 1st record through Informatica(without sequence number).
In how many ways we can create ports?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain the etl program with few examples.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is informatica?
Explain what are the different versions of informatica?
