Create a target table, here its a oracle table with same layout as source file
Start the job and review the session log, All 10 records were processed and loaded in to target.
We are done, successfully imported and loaded tab delimited flat file to a target table. Here we just used a simple mapping without formatting anything on input data, We may need to do some kind of data validation before we process through the transformation and that we will see in the next post.
Comments are closed.