A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
Answer / 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 |
sourcing in GL
where to define interorganization transaction charges and what are the different options?
What are profile options?
how can u link a org-id with a responsibility in reports?
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
Can you have two stored functions with in the same name?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
What is the difference between BPA AND Contract.
Explain what are the tables of auto invoice?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
what is the diff between custom.pll and form personalization? Tell me one example?