Answer / prabhu

Yes.we can.Use sqlplus -s command in unix to connect to
oracle from unix.Then we can execute the stored proc.

Prabhu
www.iskilltech.com

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

What is a transaction control transformation?

0 Answers   Informatica,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

how to remove staging area

1 Answers  

---

Is stop and abort are same in informatica?

0 Answers  

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---