Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


What is the difference between view and materialised view?

6 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,






Define Incremental Aggregation?

2 Answers  


in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,


what is the dashbords?

1 Answers   IBM,


What do you understand by SOA of Informatica?

0 Answers  


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  


What is rank transform?

0 Answers  






Categories