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 |
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.
can we use anchor propery in XML reports?if yes?explain?
What are the Import Programs We need to run after creating Interface table for all modules
what is organization id
In unix Schell sript what is very 1st line to be wriiten .
we have 4 managers if one person logon the system automatically displays his siganature and name how?
What are basic steps for AIM?
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
what is instead of trigger in where u will use?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
Please let me know the differance between Master Item and organization Item in Inventory.
Explain the multi-organization structure.