Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

1 Answers   TCS,

---

What is rdbms and its types?

0 Answers  

---

Explain the components of rdbms?

0 Answers  

---

What is environment of openedge?

0 Answers  

---

What is a concurrency problem in dbms?

0 Answers  

---

What are the various normalizations in database?

0 Answers   NIIT,

---

What is a candidate key in dbms?

0 Answers  

---

What are the advantages of manual database?

0 Answers  

---

Can we update table which is created from view?

2 Answers   IBM, Punjab National Bank,

---

What is a database in computer?

0 Answers  

---

What is the use of IGNORE option in IMP command ?

1 Answers  

---

Compare non-clustered and clustered index

0 Answers  

---