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...
This can be achieved by setting the APT_ORACLE_RESERVE_BLANK environment variable to TRUE.
ReplyDeleteThis 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.