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 |
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Do you know what is applysys in oracle application database schema, what is apps?
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
What is Pragma Autonomous transaction. It's Real time Example
Which module is not in multiorg
What are Mandatory triggers to write in the block, which is created on view?
Exception Handilings?
What is cursor?
can we use commit in trigger? If yes how?
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
what is user exit and wat program do we write in user exit?