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 is item status? name the related table.

1 Answers   Scan Steel,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

can u explain which situation automonus transaction is used

2 Answers  

---

In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,

---

---

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

3 Answers   Wipro,

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

What is oracle soa suite?

0 Answers  

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---

what is inbound and outbound interface?

2 Answers  

---

What is count(*) from po_vendors(any table)?

0 Answers  

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---