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

4167

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

1185

Where do we use mapping variables in informatica?

1074

What are the types of caches in lookup? Explain them.

972

what is size of u r database?

2311

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

How to load the data from people soft hrm to people soft erm using informatica?

1025

How many transformations can be used in mapplets.

1940

What do you mean by worklet?

1075

What is InformaticaPowerCenter?

1139

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

What are the types of schemas we have in data warehouse and what are the difference between them?

946

how tokens will generate?

2210

what is the hint? how to use it to reduce the query processing in program?

7843

Can we create a Integration service without a Repository service and vice versa?

1217