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 can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

what is the architecture of any Data warehousing project?

5 Answers   IBM,

Explain the aggregator transformation?

0 Answers  

how we can update a target table without update strategy and update override?

3 Answers   TCS,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

What is the status code?

1 Answers  

In ur current projectu have done any performance tuning of mappings?

1 Answers  

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

What is the difference between informatica 7.0 and 8.0?

0 Answers  

What is complex mapping?

0 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories