Answer / seshadri reddy

There were somany instances as depicted below:

1.If the customer was using some old version of oracle
Aps,If he wants to switch over to the new version.If the old
version structure is no compatable to the new version.Then
we have to transfer the data from old version tables to
flat files again from there we have to upload into the new
tables.


2.If the customer is using more than one application for his
total enterprise,since every module is interlinked we have
to transfer the data from one module to to other.In this
case we cannot transfer the data from one application to the
other directly.In this case we have to get the data into
flat files and tranfer into the next application..

Answer / bobbyiiit

when the client is using some other reporting tool. then he
need the data in the base tables so that he can load the
data in to the database on which he is generating reports.

for this purpose we transfer the data from base tables to
flat files.

the client will then load the data from the flat files to
his own data base and develop reports.

Answer / anil kumar

sashidhar reddy is correct

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

what is meant by anchoring?

3 Answers  

---

What do you understand by concurrent programs?

0 Answers  

---

You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,

---

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

what are the difference between oracle discoverer and report6i

1 Answers  

---

oracle apps architecture

1 Answers   TCS,

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---