Interested to Buy Any Domain ? << Click Here >> for more details...
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
- 1 Answers
- 5212 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / priyanka
External table is like ctl file syntax but with in database script this will pick up the file from database then load data in to staging table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What are the different components you should consider while defining a responsibility in oracle apps?
How to create a purchase order without a requisition?
What are the Standard Reports and Forms in HRMS?
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
Plz anybody send me Technical specification for AP Interface
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
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How can a process be deployed in soa?
q)what are the validations in sql*loader
what is global tempory table?
can we use look up type instead of a pofile option?or valueset?is it possible how?
Tell me where we find the status of order information?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
