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.
- 2 Answers
- 8251 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prasanna
WHILE DEVELOPING THE xml format rtf you can make condition
on the field using choose element
| Is This Answer Correct ? | 1 Yes | 1 No |
how to make a parameter optional in the query?
where we can check the status of po.
1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?
what is the difference between %_all and %_f tables
Which oracle apps version you are very confident in?
Can functions be overloaded ?
What are documents and test cases u followed.
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
What are the Major differences between appcore.pll and appcore2.pll
5 Answers Infosys, Sierra Atlantica,
in one report using two layout models.if yes how to do
What is procedure?
What is multi org?
Oracle Apps Technical 
