explain what is odi?why is it different from the other etl tools.

619

---

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

550

---

what is oracle data integrator (odi)?

625

---

how to load the data with one flat file and one rdbms table using joins?

620

---

how to reverse engineer views(how to load the data from views)?

552

---

can we implement package in package?

587

---

does odi support web services?

565

---

how to handle exceptions?

607

---

how to implement data validations?

594

---

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

689

---

how to remove the duplicate in odi?

627

---

how to write the sub-queries in odi?

704

---

in the package one interface got failed how to know which interface got failed if we no access to operator?

612

---

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

748

---

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

795

---