How can we load date type of data in month wise in informatica?

  • Interview Candidate
  • 12
  • 9759

Showing Answers 1 - 12 of 12 Answers

Walter

  • Sep 25th, 2011
 

You Can use expression transformation. Add an port as output, then use to_char(date_port, n) function.

  Was this answer useful?  Yes

mouni

  • Apr 30th, 2012
 

ex :to_char(trunc(sysdate),mm)
to_char(date,mm)

  Was this answer useful?  Yes

rakesh

  • May 18th, 2012
 

TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions