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
- 9983 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
how to make a parameter optional in the query?
Is there any limitations on responsibility assigned to a apps user?
How to move the one file from one instance to another instance? And your scripts also?
What is responsibility?
Can functions be overloaded ?
what is the back ground program run while transferring data from OM to AR?
Do you know where we can check the status of po?
List the types of flexfield?
What is MO operating units. Why it need to to set this and where .
Give a brief overview on OrderManagement.
Oracle Apps Technical 
