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
- 11702 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
In ctl file sql statements can be used by placing within "***"
eg :
SAL "(:sal>500)" ,
by which only salary above 500 will be loaded
| Is This Answer Correct ? | 1 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?
Can we create tables in apps schema?
Can you explain the difference between architecture followed in 10g & 11g?
What are the Standard Reports and Forms in HRMS?
what is pay run id ?
Explain oracle apps architecture.
Can you define an erp system?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Plz anybody send me Technical specification for AP Interface
What is oracle soa suite?
What do you understand by soa and what are the benefits of using this architecture?
what is the difference between request group and request security in oracle apps?
how do you describe O2C along with tables
List the types of flexfield?
