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
- 4160 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 is a transaction control transformation?
What is a joiner transformation and why it is an active one?
Write the unconnected lookup syntax?
What is informatica powercenter repository?
How you prepared reports for OLAP?
What is parallel processing in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
How do you promote a non-reusable transformation to reusable transformation?
What is Cognos script editor?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to Create a folder using pmrep command?
How to generate sequence numbers?
What is data caches/ index caches?
What is informatica metadata and where is it stored?
How to handle decimal places while importing a flatfile into informatica?
