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
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 |
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
what is a transforamation?
What is the difference between normal and bulk loading? Which one is recommended?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
why we r using presql&postsql in source qualifier?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Why filter transformation is an active one?
Explain factlessfact table with scenario
What is best approach to load 100 different source files (Different structure) to differet target tables ?