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.
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 |
what are the important table names in purchasing?
List the types of flexfield?
What is the concept of soa governance?
Tell me some thing about SQL-LOADER.
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
What is Summary columns?
what is the defference between credit memo and debit memo
why do we validate the records while developing interface?
What is the difference between base table and multi-org table?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
when we run payment batch what are the 3 concurrent programs?