Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


If the flat file is having the duplicate records in the
interface how can you restrict while transferring the flat
file data in to interface tables?

Answers were Sorted based on User's Feedback



If the flat file is having the duplicate records in the interface how can you restrict while trans..

Answer / swapna

AFTER LOADING THE DATA INTO STAGE TABLE USING SQL LOADER,
WE WILL WRITE THE VALIDATION PROGRAM.

IN THIS VALIDATION PROGRAM WE WILL WRITE CODE TO RESTRICT
DUPLICATE RECORDS.

SO ONLY VALID RECORDS ONLY TRANSFERRED INTO INTERFACE TABLE.

Is This Answer Correct ?    18 Yes 0 No

If the flat file is having the duplicate records in the interface how can you restrict while trans..

Answer / sharad

define primary or unique key on staging table then it
restricts duplicate data when u run sqlloader for
transfering data from flat file to staging table

Is This Answer Correct ?    14 Yes 2 No

If the flat file is having the duplicate records in the interface how can you restrict while trans..

Answer / srinivas.r

We can't restrict the duplicate records by using the SQL
*Loader.For that first move the data into Staging table and
then alidate the records before moving into interface table.
This is the process i knnow as per my knowledge.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

How do you register report in oracle apps?

0 Answers  


testing tools?

0 Answers   BirlaSoft, Convergys,


can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,


AOL?

4 Answers  


What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,


What is the difference between base table and multi-org table?

3 Answers   Infosys,


How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,


How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,


Tell me some errors names and number what u got while developing the reports?

1 Answers  


what is aim methodolozy

1 Answers   Wipro,


what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  


What is the difference between buyer&employee in PO module?

7 Answers   TCS,


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)