Answer Posted / ravi

select * from table_name pivot(sum(sales) for region in(1,2));

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

4252

---

What is primary and backup node?

1174

---

How do we call shell scripts from informatica?

1191

---

Write the advantages of partitioning a session?

1333

---

explain abt ur project architecture?

2233

---

What are the reusable transformations?

1220

---

Can informatica load heterogeneous targets from heterogeneous sources?

1233

---

What are the different lookup cache(s)?

1167

---

Explain what are the different versions of informatica?

1145

---

What is sorter transformation?

1109

---

How to call shell scripts from informatica?

1043

---

Can we create multiple integration service on single repository?

1241

---

How to extract sap data using informatica? What is abap? What are idocs?

1252

---

What is depict expression change?

1194

---

How many ways are there to create ports?

1403

---