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.
Answer Posted / ram
As per my knowledge we can not have custom validations in
loader file...the only way is have a custom validation to
restrict the records haviing sal less than 400 in your
package or procedure.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What do you understand by a set of books?
In oracle application how do you debug or trace errors?
What is a value set? List its various types.
What is count(*) from po_vendors(any table)?
Tell me how to debug the report?
what are the different transaction clauses in AR?
tell me the scenarios of the independent in reports
tell me the scenarios of the independent in reports
What is oracle soa suite and what are its different components?
What is the concept of soa governance?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Explain what are the tables of auto invoice?
In hierarchical structure of a database? we have write query from where we should start?
What are the different components you should consider while defining a responsibility in oracle apps?
Explain oracle apps architecture.