How to load data for a specific Operating Unit using the SQL*LDR Control file
Hello All,
I have a requirement to load data in to the table specific to the Org which you are in. The data file has data for multiple Operating units. When you login to the applications to a specific Operating Unit "One", and load the data file using the SQL*Loader, the control file should load data pertaining to the Operating Unit "One" alone, though it has other operating units data. Similarly, when I navigate to a different Operating Unit "Two" and load the data, the control file should restrict the load only to the records specific to the Operating Unit "Two".