Interested to Buy Any Domain ? << Click Here >> for more details...
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,
- 3 Answers
- 8356 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / yashvi
You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is domain and gateway node?
What is a snowflake schema?
How can we delete duplicate rows from flat files?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a difference between complete, stop and abort?
What is the session task and command task?
What will be the approach?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is an expression transformation?
What is dynamic cache?
Explain what are the different versions of informatica?
tell me the rules and responsblites in our project(my project is development)
How many ways are there to create ports?
How can one identify whether mapping is correct or not without connecting session?
Did u used latest transformations of 8.6.0? for what?
