Answer / susheel sharma

in our project we used store procedure to implement CDC
(change data capture) for incremental data load.

generaly store procedure used when you have to implement
your complex business logic.

Answer / grhyrngnn yjhyj

i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

How to start a workflow using pmcmd command?

0 Answers  

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

difference between stop and abort

2 Answers  

---

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

How would you join a node to the already existing domain?

0 Answers  

---