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
- 10381 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / harish
by using when clause in ctl file
ex:
load data
infile ''
fields terminated by...
trialing....
INTO TABLE tab WHEN sal>500
(col1 ...
......
.....
)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How is choreography different from orchestration?
What is instead of trigger in where we will use?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is oracle soa suite?
what is the differences between internal requisition and internal sales order?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
what is global tempory table?
is it possible to run the interface without using oracle apps?
Is soa a part of oracle fusion middleware?
Do you know where we can check the status of po?
In oracle application how do you debug or trace errors?
What are the benefits of using soa architecture?
Do you know what is applysys in oracle application database schema, what is apps?
how to print multi lay outs,muti currency,muti language in xml publisher
