Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 11700 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / abdul
in control file at sal column write "(:sal>500)"
ex:
sal "(:sal>500)";
then we insert only sal >500 records into staging table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how can i print random rows in plsql table
Tell me how to find the custom directory in front end?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what are the different transaction clauses in AR?
List the various types of value set.
q)what are the validations in sql*loader
Is soa a part of oracle fusion middleware?
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
Plz anybody send me Technical specification for AP Interface
tell me the scenarios of the independent in reports
What is oracle soa suite and what are its different components?
do you know is it possible to run the interface without using oracle apps?
What does appl_top directory contain?
Can you differentiate between mediator and osb?
