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
- 11701 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by a set of books?
Can u give the Documentation of Custom.pll in oracle apps
What is instead of trigger in where we will use?
can we use look up type instead of a pofile option?or valueset?is it possible how?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by soa?
q)what are the validations in sql*loader
What is a flexfield? List out its types.
Tell me how to find the custom directory in front end?
how to print multi lay outs,muti currency,muti language in xml publisher
List the various types of value set.
How to move the one file from one instance to another instance? And your scripts also?
what is the differences between internal requisition and internal sales order?
how can i print random rows in plsql table
How to create a purchase order without a requisition?
