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 / ramesh babu v
we can werite the condition in trailing null cols
like
trailing nullcols(sal number(10)check(sal<500));
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
where to define interorganization transaction charges and what are the different options?
How do you register report in oracle apps?
What is sca and how is it useful?
What do you understand by concurrent programs?
what is global tempory table?
What are the different components of soa suite?
In hierarchical structure of a database? we have write query from where we should start?
How is choreography different from orchestration?
What is instead of trigger in where we will use?
What are do's and dont's of Interface?
what is the difference between request group and request security in oracle apps?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Which oracle apps version you are very confident in?
What is the concept of soa governance?
Can we create tables in apps schema?