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 |
what type of testing u r doing?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
in one report using two layout models.if yes how to do
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
where we find the status of order information.
what is pl/sql table and pl/sql records? what is the use of that?
Tell me how to find the custom directory in front end?
Is SOB is attached with Business grp ?
what are the prerequisites for costing transactions?
What is cursor?
What are the files you have used in the part of Conversion and Interfaces?
Give a brief overview on OrderManagement.