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.
- 2 Answers
- 7193 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you achieve loose coupling in soa framework?
How do you register report in oracle apps?
What is the concept of soa governance?
what is the differences between internal requisition and internal sales order?
how do you describe O2C along with tables
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
what are the balancing segments in AR?
what are the prerequisites for costing transactions?
what is global tempory table?
how to print multi lay outs,muti currency,muti language in xml publisher
can we use look up type instead of a pofile option?or valueset?is it possible how?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is sca and how is it useful?
