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
- 3461 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
What are the differences between joiner transformation and source qualifier transformation?
Explain sessions and how many types of sessions are there?
what is index?how it can work in informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Enlist few areas or real-time situations where informatica is required.
What is transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the procedure for creating independent data marts from informatica 7.1?
What could be the possible resons of locks by user?
can anyone suggest best free Talend data integration training online
define galaxy repository in informatica
Explain the different kinds of facts.
What are pre and post-session shell commands?
Why do you use Mapping Parameter and mapping variable?
explan ur project architecture?
