Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4145 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
which one is better performance wise joiner or look up
What is mapping debugger?
Can we create multiple integration service on single repository?
What is the function of look up transformation?
How to partition the Session?
What is depict expression change?
What can we do to improve the performance of informatica aggregator transformation?
What is rank transform?
How to elaborate tracing level?
What is rank index in rank transformation?
What is decode in static cache?
What are the components of workflow manager?
explain abt ur project architecture?
How big was your fact table
What are the tasks that source qualifier perform?
