INBOUND INTERFACE: Suppose I have 100 Records of employees
in flat file.When moving the records from flat file to
STAGING table using .CTl file, I want to restrict the
records whose salary is less than 500.what are the
validations(or conditions) you write to achieve this.
Answers were Sorted based on User's Feedback
Answer / basha
we can apply the condotion by using 'when sal<500' before
columns name and after the into statemnt
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prasanna
WHILE DEVELOPING THE xml format rtf you can make condition
on the field using choose element
Is This Answer Correct ? | 1 Yes | 1 No |
how i can create temporary table?
what is organization id
In Per_all_people_f table what is the significance of '_f ' ?
what is the differences between internal requisition and internal sales order?
what is difference between d2k report and oracle apps report
If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?
in one report using two layout models.if yes how to do
What is the difference between BPA AND Contract.
Which module is not in multiorg
What do you understand by soa and what are the benefits of using this architecture?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??