1

I'm creating Windows file through Informatica using codepage UTF 8 ( I tried other code pages as well). First I'm creating/writing file with header record and then appending detail records in same file. The issue is there are Null Characters appearing in between header and first detail record. Could anyone advise why Null Characters are appearing and how can they be removed? Thanks

Syed Mohammed Mehdi
  • 183
  • 2
  • 5
  • 15
  • what's the source? how u are populating it? – MOHAMMED SHEIK DAWOOD S J Feb 21 '18 at 07:17
  • Source is a file and it is not getting any null character and the issue is when I'm writing header and detail in separate file then we are not getting any null character but when I'm writing detail record in same file of header then we are getting these null characters after header record – Syed Mohammed Mehdi Feb 21 '18 at 10:39
  • Is the header file a fixed length or delimeted file? Are you creating the two files in same mapping (and using target load plan to control which gets created first) or separate mappings? – Daniel Machet Feb 22 '18 at 07:09
  • Not sure why you've been downvoted given this is a valid issue. Please share the details I've asked for – Daniel Machet Feb 23 '18 at 06:59
  • Check your character encoding again. When I had a similar problem, it was because the source really was UTF-16 encoded, not UTF-8. – kutschkem Mar 13 '18 at 07:30

1 Answers1

0

There are lot of things you have to look at,

  1. Check the source , whether you are getting that null character from the source.
  2. Cross check the transformation used once.

Even after that if you are getting the NULL character , then go ahead and delete the those NULL character from the file using BATCH script that will be called in the post success command.

MOHAMMED SHEIK DAWOOD S J
  • 81
  • 1
  • 4
  • 18
  • Source is a file and it is not getting any null character and the issue is when I'm writing header and detail in separate file then we are not getting any null character but when I'm writing detail record in same file of header then we are getting these null characters after header record – Syed Mohammed Mehdi Feb 21 '18 at 10:40
  • I am not getting your whole scenario, still I suggest while you loading details data , In session property , select "No header " option – MOHAMMED SHEIK DAWOOD S J Feb 22 '18 at 07:33