A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
- 1 Answers
- 6438 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sandeep kumar
Its simple, in all the standard Interface tables there will be some thing a column named header_id, say suppose if you are inserting the header records then you need to provide the header_id in the headers table, In the corresponding child interface tables there will to columns one for the header_id which stores the same header_id which you had provided for the earlier header records and another column for line_id so insert the corresponding lines in the lines table with the same header_id.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is soa a part of oracle fusion middleware?
can we get profile values in report without using user exists is it possible how?
What is oracle soa suite and what are its different components?
can we use look up type instead of a pofile option?or valueset?is it possible how?
In support project one ticket alloted which steps follows manualy tell me ?
How to move the one file from one instance to another instance? And your scripts also?
Explain what are the tables of auto invoice?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Can you explain the difference between architecture followed in 10g & 11g?
q)what are the validations in sql*loader
tell me the scenarios of the independent in reports
What are the benefits of using soa architecture?
What is the concept of soa governance?
What do you understand by concurrent programs?
What does appl_top directory contain?
