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 / bk
TO_CHAR(DOJ_port, 'MMDDYYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is main use of mapplet?
Can we create a Integration service without a Repository service and vice versa?
What are the differences between joiner transformation and source qualifier transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is $$$$?
How union transformation is used?
What is dimensional table?
How to Create a folder using pmrep command?
How to elaborate tracing level?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the benefit of session partitioning?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What do you mean incremental aggregation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to start a workflow using pmcmd command?