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
- 11513 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
What is sca and how is it useful?
What are do's and dont's of Interface?
How to create a purchase order without a requisition?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
tell me the scenarios of the independent in reports
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by a set of books?
How to move the one file from one instance to another instance? And your scripts also?
How can a process be deployed in soa?
List the types of flexfield?
Can you differentiate between mediator and osb?
Tell me how to find the custom directory in front end?
What is a flexfield? List out its types.
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What are the different components you should consider while defining a responsibility in oracle apps?
