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 flexfield qualifier?

3 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,


Explain the multi-organization structure.

1 Answers   Accenture,


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,






how to use .prt file in bitmap reports?

2 Answers   Accenture,


What is responsibility and how u attach

5 Answers   Accenture,


How many phases of implementation and what are those.

2 Answers   Accenture,


When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,


how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,


please send me forms, xml pulisher questions,answers

0 Answers   Zensar,


what is meant by anchoring?

3 Answers  


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)