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
Under which circumstances, informatica server creates reject files?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Differences between version 7.x and 8.x.
tell me 5 session failure in real time how can you solve that in your project?
Name the different lookup cache(s)?
What is the different lookup cache(s)?
Describe the impact of several join conditions and join order in a joiner transformation?
What you know about transaction control transformation?
Explain how to import oracle sequence into informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Write the advantages of partitioning a session?
How can a transformation be made reusable?
where to store informatica rejected data?
What is meant by pre and post session shell command?
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.