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
- 11242 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
What is a flexfield? List out its types.
how to print multi lay outs,muti currency,muti language in xml publisher
How many schemas we have? how many you have used?
What is oracle soa suite?
please send me forms, xml pulisher questions,answers
List the various types of value set.
How do you register report in oracle apps?
what are the prerequisites for costing transactions?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Can we create tables in apps schema?
Plz anybody send me Technical specification for AP Interface
In support project one ticket alloted which steps follows manualy tell me ?
where to define interorganization transaction charges and what are the different options?
what is the difference between request group and request security in oracle apps?
