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 |
Can u attach Request set with in the Request set?
What are basic steps for AIM?
What is the use of format trigger?
what is instead of trigger. what is the use of that?
What is MO operating units. Why it need to to set this and where .
In which directory your flatfile is given?if u connected different instance where it is find?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
How many parameters we can pass through pl/sql program in Oracle apps
what is meant by Drill Down in Discoverer report? why it will be use?
Registering parametric report?
What is instead of trigger in where we will use?