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
- 7363 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
How can you define user defied event?
What are junk dimensions?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is SDLC way of code development?
Explain about cumulative Sum or moving sum?
What do you understand by SOA of Informatica?
Reusable transformation and shortcut differences
Define enterprise data warehousing?
Do you find any difficulty while working with flat files as source and target?
How can we use mapping variables in informatica?
Under which circumstances, informatica server creates reject files?
What is the need for an etl tool?
How union transformation is used?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Define pmcmd command?
