Geeks Talk

Prepare for your Next Interview




Get the data into data file while uploading

This is a discussion on Get the data into data file while uploading within the Oracle Apps forums, part of the Enterprise Solutions category; How can we get the data into data file while uploading the data from legacy systems to apps base tables. What are the steps involved in getting the data into ...


Go Back   Geeks Talk > Enterprise Solutions > Oracle Apps

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 12-30-2006
Expert Member
 
Join Date: Oct 2006
Posts: 690
Thanks: 0
Thanked 49 Times in 41 Posts
JobHelper is on a distinguished road
Get the data into data file while uploading

How can we get the data into data file while uploading the data from legacy systems to apps base tables.
What are the steps involved in getting the data into data file.

NOTE : [This question was asked by viswanath]
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-03-2007
Junior Member
 
Join Date: Mar 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
siva sankar is on a distinguished road
Re: Get the data into data file while uploading

Hi,

first we get the flat file from the client.(i.e .dat,.txt),
then we create the staging table and upload the data from flat file to staging table using sql*loader.

if any queries please let me know..
Thanks,
Siva Sankar
Reply With Quote
Reply

  Geeks Talk > Enterprise Solutions > Oracle Apps


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Append data to a target file JobHelper Data Warehousing 3 06-28-2007 11:27 AM
Data generator sutnarcha Testing Issues 0 12-27-2006 04:15 AM
data conversion jaindharmendrakumar SQL 0 11-21-2006 05:57 AM
Data type in SQL blenda Oracle 2 06-29-2006 02:16 PM


All times are GMT -4. The time now is 02:02 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved