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
- 11410 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 do you understand by concurrent programs?
How to move the one file from one instance to another instance? And your scripts also?
Do you know what is applysys in oracle application database schema, what is apps?
Tell me where we find the status of order information?
What are the benefits of using soa architecture?
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.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
In hierarchical structure of a database? we have write query from where we should start?
Explain what are the tables of auto invoice?
what is pay run id ?
what are the prerequisites for costing transactions?
Can you explain the difference between architecture followed in 10g & 11g?
Explain oracle apps architecture.
tell my any difficult situtation you solved in your experience in your company?
