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,
Answers were Sorted based on User's Feedback
Answer / yashvi
You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')
Is This Answer Correct ? | 6 Yes | 0 No |
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 |
Define update strategy?
What are Business Components in Informatica?
How to join three sources using joiner?
What is the meaning of up gradation of repository?
What are Dimensions and various types of Dimensions?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What are the components of workflow manager?
What is the target load order?
What are 2 modes of data movement in Informatica Server?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Where can we find the throughput option in informatica?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.