Answer / Vipin Kumar Divakar

In Oracle, you can use SQL*Loader to load a flat file into multiple staging tables. Here's an example:

First, create the control file with the following structure:

```
OPTIONS (SKIP=1)
LOAD DATA
INFILE '<flat_file_location>'
APPEND
INTO TABLE <staging_table_1>
FIELDS TERMINATED BY ','
(
field1 CHARACTER SET ascii,
field2 CHARACTER SET ascii,
...
)

LOAD DATA
INFILE '<flat_file_location>'
APPEND
INTO TABLE <staging_table_2>
FIELDS TERMINATED BY ','
(
field1 CHARACTER SET ascii,
field2 CHARACTER SET ascii,
...
)
...
```

Replace `<flat_file_location>` with the location of your flat file and add more control statements for each staging table you want to load data into. Then run the SQL*Loader using the control file.

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1 Answers  

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

1. What is PO rate variance gain and loss?

1 Answers   Oracle,

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

1 Answers   L&T,

---

How many segment are present in Oracle Manufacturing

1 Answers   Oracle,

---

what is correlated subquery

3 Answers  

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

how to write customizations in po

1 Answers   Ernst Young,

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1 Answers  

---