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 |
which is the table for storing organization information?
9 Answers Infosys, Scan Steel,
What is the concept of soa governance?
How many schemas we have? how many you have used?
In oracle application how do you debug or trace errors?
FLEX FIELDS?
What are the validations you don in .CTL file in inbound interface process?
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
when we run payment batch what are the 3 concurrent programs?
Can we create tables in apps schema?
What is workflow?Explain with a example?
Can u define DFF with in the DFF,How?
where is setup of business group done?