Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11540 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 |
Is it possible to do purchase order without requisition?
How to create user and how u attach with responsibility.
how can i print random rows in plsql table
what are the functions you are used in utl_file at the time of transferring the data?
What are the Major differences between appcore.pll and appcore2.pll
5 Answers Infosys, Sierra Atlantica,
AOL?
Can u give the Documentation of Custom.pll in oracle apps
What is the difference between buyer&employee in PO module?
In a Standard form a DFF is disable?How we can Enable it?
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
How many schemas we have? how many you have used?
what is meant by anchoring?
Oracle Apps Technical 
