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.

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

what is the difference between procedure and function

3 Answers   Wipro,

---

wht r the basetables of customer interface?

2 Answers  

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

Who information?s?

2 Answers  

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---

what r the objects u have to do in u experiance

1 Answers  

---

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

---

After deploying like forms,reports into server how we connect this forms,reports to web?

1 Answers   IBM,

---