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...

My source is this
year
01/jun/2014
04/may/2015
09/mar/2017

my desired output is
day month ye
01 jun 2014
04 may 2015
09 mar 2017
how do i acheive this

Answer Posted / isha

to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076


How can we remove the duplicates from flat file source?

948


During the running session, output files are created by informatica server. Enlist few of them.

931


Parameter and variable differences

2005


What is decode in static cache?

1078


Explain incremental aggregation in informatica

1064


Partition, what happens if the specified key range is shorter and longer

2433


What is informatica powercenter repository?

1141


What is rank transform?

941


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2021


Enterprise data warehouse your projects phase by phase explain?

1856


Whats the difference between informatica powercenter server, repositoryserver and repository?

1112


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2253


What are the components of the workflow manager?

1079


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4677