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

622

---

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

552

---

what is oracle data integrator (odi)?

628

---

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

624

---

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

554

---

can we implement package in package?

590

---

does odi support web services?

567

---

how to handle exceptions?

608

---

how to implement data validations?

596

---

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

691

---

how to remove the duplicate in odi?

630

---

how to write the sub-queries in odi?

706

---

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

615

---

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

750

---

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

800

---