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
- 7094 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / bk
TO_CHAR(DOJ_port, 'MMDDYYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
how to load dimension table and fact table. plz tell me the steps.
What is joiner change?
Define mapplet?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What does cheating measurement mean?
What you know about transaction control transformation?
what is the complex transformation you used in informatica
What do you mean by blocking transformation?
How can we improve session performance in aggregator transformation?
How do we call shell scripts from informatica?
Is there any way to read the ms excel datas directly into informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is data caches/ index caches?
