Answer / rajiv

LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)

Answer / emmanuel - tcs

A Small changes in above control file

Add below insert stmt to above CTL File
Insert into Table Tab_name_1 -- This is for one table
Insert into Table Tab_name_2 -- This is for Second Table

First mention first table column and mention second table
columns

Answer / bobbyiiit

Using "When"

we use "When" condition to load data into multiple tables.

Syntax:

Load Data infile '&1'
Insert into table table1
(
.
.
.
.
)
Insert into table table2
when <condiation>
(
.
.
.
);

What does appl_top directory contain?

0 Answers  

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,

---

what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

---

What do you understand by a set of books?

0 Answers  

---

How many typres of Purchase order and what are those.

2 Answers   Accenture,

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  

---

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

2 Answers   Tech Mahindra,

---

How do u identity its name of report?

3 Answers  

---

we have 4 managers if one person logon the system automatically displays his siganature and name how?

1 Answers   BirlaSoft,

---

what is meant by Table space?

2 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,

---