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.
Answer Posted / basha
we can apply the condotion by using 'when sal<500' before
columns name and after the into statemnt
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is a flexfield? List out its types.
In hierarchical structure of a database? we have write query from where we should start?
can we use look up type instead of a pofile option?or valueset?is it possible how?
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.
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What are the Standard Reports and Forms in HRMS?
q)what are the validations in sql*loader
What do you understand by soa and what are the benefits of using this architecture?
what is global tempory table?
List the types of flexfield?
what are the prerequisites for costing transactions?
Which oracle apps version you are very confident in?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What is instead of trigger in where we will use?
what are the balancing segments in AR?