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



INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / abdul

in control file at sal column write "(:sal>500)"
ex:
sal "(:sal>500)";

then we insert only sal >500 records into staging table

Is This Answer Correct ?    5 Yes 0 No

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / 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

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / santosh kumar

In ctl file sql statements can be used by placing within "***"

eg :

SAL "(:sal>500)" ,

by which only salary above 500 will be loaded

Is This Answer Correct ?    1 Yes 0 No

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / shaikshavali

BY USING BUSINES RULE VALIDATION WE CAN.

Is This Answer Correct ?    0 Yes 0 No

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / harish

by using when clause in ctl file
ex:
load data
infile ''
fields terminated by...
trialing....
INTO TABLE tab WHEN sal>500
(col1 ...
......
.....
)

Is This Answer Correct ?    0 Yes 1 No

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records fr..

Answer / ram

As per my knowledge we can not have custom validations in
loader file...the only way is have a custom validation to
restrict the records haviing sal less than 400 in your
package or procedure.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is item status? name the related table.

1 Answers   Scan Steel,


When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,


is it possible to run the interface without using oracle apps?

0 Answers  


What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,


in one report using two layout models.if yes how to do

3 Answers   Wipro,






what is the diff between custom.pll and form personalization? Tell me one example?

4 Answers   Oracle,


Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,


what is the difference between procedure and function

4 Answers  


Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,


List the types of flexfield?

0 Answers  


What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,


what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)