Answer / srinivas.r

We are having to two types the error records.....
1)Rejected by the SQL Loader.
These are stored in the '.BAD' file......
2)Rejected by the condition which have been mention in the
control file.
These are stored in the '.dis' file......

atfer getting the error records in the specified file then
we will correct the errors and proceed them once again...

Answer / roshan

if where clause doesn't satified the condition and flatfile
error, so we can refer discardfile.... and debug the errors

can u explain which situation automonus transaction is used

2 Answers  

---

Types of cursors?

3 Answers  

---

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

what is the data type of lexical parameter?

5 Answers   Wipro,

---

What is instead of trigger in where we will use?

0 Answers  

---

what is item status? name the related table.

1 Answers   Scan Steel,

---

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?

3 Answers   Accenture,

---

what is flexfield qualifier?

3 Answers  

---

where the accounting related data is stored ?

2 Answers  

---

What are the tables in GL?

3 Answers   Convergys,

---

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---