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

in procedure how to return a value

2 Answers   Wipro,

---

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

---

HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  

---

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers   Accenture,

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

---

In report we have to show two Layout? how it is and how we can see from where it?

3 Answers   IBM,

---

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

1 Answers   CTS,

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

How do u identity its name of report?

3 Answers  

---

how many layout sections are tehre in layout editor?

1 Answers  

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---

How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,

---