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
- 4082 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
Briefly define a session task?
What is the need of an ETL tool?
How to Create a folder using pmrep command?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Briefly define reusable transformation?
Define enterprise data warehousing?
What are the new features of Power Center 5.0?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain why we use partitioning the session in informatica?
Can you use flat files in Mapplets.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the static cache and dynamic cache in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is expression transformation?
