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
- 4061 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
without table how to come first record only in oracle?
What the difference is between a database, a data warehouse and a data mart?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the difference between Active and Passive transformation?
How many ways a relational source definition can be updated and what are they?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is dynamic cache?
Under what condition selecting sorted input in aggregator may fail the session?
What is a repository? And how to add it in an informatica client?
Is it possible to define a single node as a Gateway node as well as worker node?
what is index?how it can work in informatica
Briefly define a session task?
How to use procedural logic inside infromatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is resilience time?
