Food for Thought - Episode 2 (Answered)

Scenario: Read a dataset and load a Oracle table using Oracle Enterprise Stage with "Load" option. The table to be loaded has a column named "X" and defined as VARCHAR2.

Challenge: Column "X" in the dataset has some values in it with leading and trailing spaces and some with pure spaces. How would you make sure that while loading the data these spaces should not be removed or converted into NULL?

Give this challenge a shot. Reply

Happy Working...

Posted at : Error and Fix Travel // 10:42 PM
Kategori:

1 comments:

  1. This can be achieved by setting the APT_ORACLE_RESERVE_BLANK environment variable to TRUE.

    This environment variable will make sure that the SQL loader would keep the spaces while loading the data and would not replace the blanks with NULLS.

    ReplyDelete

 
geekarticles.blogspot.com. Powered by Blogger.