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



Hi, I want to change date type char value integer value? I tried alter table tab_name modify (ne..

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

Post New Answer

More Informatica Interview Questions

 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?

2 Answers   DELL,


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

3 Answers   iGate,


what is a transforamation?

5 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


why we r using presql&postsql in source qualifier?

1 Answers   HP,


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?

2 Answers  


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

0 Answers   TCS,


Why filter transformation is an active one?

0 Answers  


Explain factlessfact table with scenario

1 Answers   HCL,


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


Categories