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

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

Question Posted / maco

Answers were Sorted based on User's Feedback



My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye..

Answer / kumar

use reg_extract

refer this link
https://etltechsolutions.wordpress.com/2016/06/01/using-reg_extract/

its has the logic u need to change a bit as you have char as month.

Is This Answer Correct ?    0 Yes 0 No

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye..

Answer / isha

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Separate from an archive server and a powerhouse?

0 Answers  

Parameter and variable differences

0 Answers  

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

what is size of u r database?

0 Answers  

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

What is Cognos script editor?

0 Answers   Cognizant,

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

What are the advantages of informatica?

0 Answers  

WHAT IS FACT TABLES?

2 Answers  

For more Informatica Interview Questions Click Here
Categories