Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use RECNUM special field in a file bulk load interface (sqlldr)

xkbFeb 4 2011 — edited Feb 4 2011
Hi,

I'm trying to load an ordered set of full text lines from a flat file using Sql Loader 11.2 with ODI 11.1.1 bulk LKM (LKM File to Oracle - SQLLDR).

I have to keep track of each line number in a separate target table column NUM_SEQ and feed it with sqlldr RECNUM special field.

I haven't found any other way to do that but to tweak manually the generated sqlldr .ctl control file (bad but it works) :

(
NUM_SEQ RECNUM,
FULL_LINE CHAR(4000)
)

I've tried to map "RECNUM" as an expression in the map tab of the loading interface but the column itself gets discarded at .ctl generation.

I haven't found any mention of RECNUM in the whole ODI documentation, neither on this forum nor the Web.

Using an internal Oracle sequence in the subsequent steps of the ETL breaks the garantee of ordered lines.

Any hint ?
This post has been answered by Ankit J on Feb 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 4 2011
#business-intelligence-applications, #data-integrator, #system-management-and-integration
2 comments
5,589 views