I have table name called Team and I have name and DOJ in
that table in oracle, when I retrive the table in
Informatica DOJ shows with date and time , I want want to
know is it possible to get only date(MMDDYYYY) in the date
data type,

Answer Posted / srinu

oracle support range
Jan 1, 1753 AD
to
Dec 31, 9999 AD

in informatica
The default date display format is
DY MON DD HH 24:MI:SS YYYY.
When you specify a date display format,
it displays in the test window. An invalid date display
format is marked invalid.

if u not able to Understand,,,,

Please send the Question Clearly,,,,srinu

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under which circumstances, informatica server creates reject files?

680


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

2219


Differences between version 7.x and 8.x.

1519


tell me 5 session failure in real time how can you solve that in your project?

1736


Name the different lookup cache(s)?

809






What is the different lookup cache(s)?

712


Describe the impact of several join conditions and join order in a joiner transformation?

733


What you know about transaction control transformation?

645


Explain how to import oracle sequence into informatica?

675


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1566


Write the advantages of partitioning a session?

852


How can a transformation be made reusable?

749


where to store informatica rejected data?

766


What is meant by pre and post session shell command?

737


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

900