What are the validations you don in .CTL file in inbound
interface process?
Answer / emmanuel - tcs
1) we can eliminate the records by using the WEHN condition
in CTL File
2) we can use the SQL Built-in Functions in CTL File.
3) we can skip the particular column -- Filler
4) we can Skip the top number of records -- Skip
Thanks,
Emmanuel - TCS
| Is This Answer Correct ? | 8 Yes | 1 No |
where to define interorganization transaction charges and what are the different options?
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 are the Import Programs We need to run after creating Interface table for all modules
FLEX FIELDS?
how i can create temporary table?
what are the prerequisite set ups for inter organization transaction?
What do you understand by concurrent programs?
How will u register concurrent request ?
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
What is ERP? Architecture of apps?
What is the difference between buyer&employee in PO module?
What is the difference between base table and multi-org table?