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

3775

what is INFORMATICA TESTING process

2036

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1771

What is rank transformation?

750

How to load last n records of file into target table - informatica

833

Can anyone tell me the new features in Informatica 9 Version?

1757

How to partition the Session?

839

What is meant by target load plan?

733

What is olap (on-line analytical processing?

819

What is Cognos script editor?

3951

What is the function of look up transformation?

856

What are the tasks that source qualifier perform?

822

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5334

What is event and what are the tasks related to it?

812

How to do unit testing in informatica? How to load data in informatica ?

877