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.

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

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.

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  

---

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

0 Answers  

---

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

---

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

tell me the scenarios of between pages in reports

5 Answers  

---

How can a process be deployed in soa?

0 Answers  

---

sourcing in GL

1 Answers   Convergys,

---

what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---

how to enable Zoom function and steps?

1 Answers   Patni,

---