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
- 3794 Views
- IBM, I also Faced
- E-Mail Answers
Answer / vas.chiky
take one copy of master table as table_copy.
add a new column say "numeric" to the existing master table.
truncate the master table.
In informatica designer,
1.table_copy as source and master table as target.
2.have one expression trasformation. add one field numeric
(integer datatype).
expression coundition: iff (old_value = 'Y',1,0)
provide the connections.
create new workflow and start. The data will be loaded to
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
How many ways are there to create ports?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to use Normalizer transformation?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
How can u work with remote database in informatica?did you work directly by using remote connections?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
Roles and Responsibilties of Informatica Production Support Member?
how do u move the code from development to production?
How to generate sequence numbers using expression transformation?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
what is the mechanism of the Master-Detail joining condition?
Teradata 
