Skip to main content
Question

Null value handling from Oracle to PostgreSQL (PG)

  • March 10, 2021
  • 4 replies
  • 103 views

bluewater

I have a migration job from Oracle to PostgreSQL (PG). Null values in Oracle appear to be empty strings in PG. Null values are in both numeral and char data types. If I want all null values in Oracle to be also null value in PG, what transformer or method should I use for this migration? Thanks.

4 replies

Forum|alt.badge.img+2
  • 1891 replies
  • March 10, 2021

@bluewater​ FME should be preserving the <null> values from Oracle to PostgreSQL . If you look at your data using FME Data Inspector or Visual Preview you should see <null> dialogCheck that your source Oracle data does actually have <null> field values and that they are not just Empty or Blank. You can use the NullAttributeMapper transformer to force values to <null>


bluewater
  • Author
  • 2 replies
  • March 10, 2021

Thank you for your kind comment, @Mark Stoakes​. Yes, I have confirmed that the original Oracle tables have null values and those null values are not coming through correctly in the destination PostgreSQL database table.

I tried to use NullAttributeMapper transformer, but I may not be using that correctly. It is still not working.


Forum|alt.badge.img+2
  • 1891 replies
  • March 11, 2021

@bluewater​ You probably have to take this up with your local FME support organization. As far as I can tell, support for <null> is working OK in FME between Oracle & PostgreSQL. So there must be something else going on. (Unless you are using a very old version of FME before we added <null> support circa 2014/2015)


bluewater
  • Author
  • 2 replies
  • March 11, 2021

I use 2018 version. Ok, I will seek support from our vender. Thanks you for your time!