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 |
AOL?
wht r the basetables of customer interface?
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
can we pass bind variablein lexical parameter?
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
why r u move in the cus_top only why not move another top
Name the different Cursor Attributes.
In what situation u create the BPA.
can we write sql statement in Format trigger?
What is the autonomous transaction?give me example?