In one flat file i got headers and lines data how you can write control file now ?

Answer Posted / ramesh

load(skip=1)
data
infile
.....
This command removes the header data. It just inserts the lines data into staging tables

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the types of flexfield?

782


What do you understand by a set of books?

819


What is oracle soa suite?

957


In support project one ticket alloted which steps follows manualy tell me ?

2410


What is count(*) from po_vendors(any table)?

813


what are the balancing segments in AR?

1834


Explain what are the tables of auto invoice?

868


What are file in oracle.

1995


How can a process be deployed in soa?

885


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1833


Can we create tables in apps schema?

836


Tell me where we find the status of order information?

906


testing tools?

1951


In oracle application how do you debug or trace errors?

847


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2110