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
- 11328 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 |
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Tell me some interface tables on ordermangement.
How does accounting occured in Expense Reporting?
What should be the batch size (number of customer records) general guidelines for optimal performance?
What are file in oracle.
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
tell me the scenarios of between pages in reports
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
in procedure how to return a value
what are the types of interfacing?
how many sections are there in report?
Please let me know the differance between Master Item and organization Item in Inventory.
Oracle Apps Technical 
