Home » Applications » Oracle Fusion Apps & E-Business Suite » Interfacing in two steps??
Interfacing in two steps?? [message #119528] Fri, 13 May 2005 03:14 Go to next message
theone
Messages: 6
Registered: March 2005
Location: Jabalpur
Junior Member
Hi,

I have a problem related to interfacing.
Suppose we have some legacy records in the form of Xl files.
The count will be 20 lacks.
Now what we do in Sql*loader we give the path name and the not null columns.
and run the loader.
this data will go to the interface table of corresponding module.
now my questions are
1, this data is validated and dumped into columns in interface tables and then forwarded to apps thru import prog.

so is there any way to do this whole process in two steps so that we recieve the data in to apps database easily.

2, For 20 lacks record, hw many times u need to run loader, bcoz it will take time to validate and dump it in to data base.

3,if there is any error, how we will trace the error.

thanks for ur help.

Regards,

abhi

Report message to a moderator

Re: Interfacing in two steps?? [message #126531 is a reply to message #119528] Tue, 05 July 2005 07:28 Go to previous message
ravinderid
Messages: 3
Registered: March 2005
Location: Hyderabad
Junior Member
hi abhi,

Save all path in a txt file,then create a unix script which reads this file and put it in a loop takes one file path at a time and execute the sqlloader from that script till the txt file encounter EOF

Thanks

Report message to a moderator

Previous Topic: Customer URGENT!!!!
Next Topic: DFF
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 16:14:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.