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
- 10208 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
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
can we get profile values in report without using user exists is it possible how?
What is instead of trigger in where we will use?
What are the different components you should consider while defining a responsibility in oracle apps?
what is pay run id ?
What does appl_top directory contain?
In support project one ticket alloted which steps follows manualy tell me ?
Explain oracle apps architecture.
please send me forms, xml pulisher questions,answers
Do you know where we can check the status of po?
How can you achieve loose coupling in soa framework?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what is global tempory table?
What is sca and how is it useful?
Do you know what are user profiles in apps. Any examples you can give?
