Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / 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

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

what is incremental aggregation ,with example?

2 Answers  

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

what is hash table in informatica?

1 Answers   Zensar,

Where do we use mapping variables in informatica?

0 Answers  

If informatica has its scheduler why using third party scheduler?

0 Answers  

What are the types of presistent cache in look up tr.

0 Answers   IBM,

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

what are the perameter and variable?

3 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories