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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ramesh babu v
we can werite the condition in trailing null cols
like
trailing nullcols(sal number(10)check(sal<500));
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santosh kumar
In ctl file sql statements can be used by placing within "***"
eg :
SAL "(:sal>500)" ,
by which only salary above 500 will be loaded
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / ram
As per my knowledge we can not have custom validations in
loader file...the only way is have a custom validation to
restrict the records haviing sal less than 400 in your
package or procedure.
Is This Answer Correct ? | 0 Yes | 3 No |
what is item status? name the related table.
When you run he report you have to get only that particular organization po numbers or item number how can do it?
is it possible to run the interface without using oracle apps?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
in one report using two layout models.if yes how to do
what is the diff between custom.pll and form personalization? Tell me one example?
Challenges faced during upgradation of 11i to R12
what is the difference between procedure and function
Difference between set of books id and ledger id in r12 ?
List the types of flexfield?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,