Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Explain the shared cache and re-cache?

0 Answers  

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

What are the components of the workflow manager?

0 Answers  

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

What is query panel?

1 Answers  

---

Can you generate reports in Informatcia?

1 Answers  

---

What are the modules in Power Center

0 Answers  

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---