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


Please Help Members By Posting Answers For Below Questions

where to define interorganization transaction charges and what are the different options?

1959


How do you register report in oracle apps?

635


What is sca and how is it useful?

663


What do you understand by concurrent programs?

621


what is global tempory table?

6313






What are the different components of soa suite?

726


In hierarchical structure of a database? we have write query from where we should start?

1708


How is choreography different from orchestration?

655


What is instead of trigger in where we will use?

680


What are do's and dont's of Interface?

1905


what is the difference between request group and request security in oracle apps?

5053


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2097


Which oracle apps version you are very confident in?

707


What is the concept of soa governance?

776


Can we create tables in apps schema?

622