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
- 7433 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
testing tools?
tell me the scenarios of the independent in reports
What is oracle soa suite?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
tell me the scenarios of the independent in reports
What is a flexfield? List out its types.
what are the balancing segments in AR?
what are the different transaction clauses in AR?
where to define interorganization transaction charges and what are the different options?
Are you familiar with internet architecture of oracle apps 11i?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
How is choreography different from orchestration?
How to move the one file from one instance to another instance? And your scripts also?
tell my any difficult situtation you solved in your experience in your company?
How can you achieve loose coupling in soa framework?
