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

what are challenges that you faced in testing? give solution to it?

1 Answers  

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

what is diff between grep and find

3 Answers   IBM, iFlex,

What all join we can perform in LOOKUP transformation?

0 Answers  

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

what is the function of 'F10' informatica ?

4 Answers   IBM,

Can you use flat files in Mapplets.

0 Answers  

How to delete duplicate records in a flat file source?

2 Answers  

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

For more Informatica Interview Questions Click Here
Categories