Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source which relational.I am trying to populate to
target flat file with one column for daily date which is
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY
format.
kindly provide a solution for this..my clear that my target
is flat file.
- 3 Answers
- 7103 Views
- I also Faced
- E-Mail Answers
Answer Posted / aakansha
In expression write following if target field is defined
with DATE datatype:
TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'))
If target field defined with character datatype then use:
TO_CHAR(SYSDATE,'DD/MM/YYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How to call shell scripts from informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the advantages of informatica?
What is target load order?
What are the advantages of using informatica as an etl tool over teradata?
permutations of mapplet
What is lookup change?
Sequence generator, when you move from develoment to production how will you reset
write a query to retrieve the latest records from the table sorted by version(scd)
Write the advantages of partitioning a session?
How to join three sources using joiner? Explain though mapping flow.
What are the different types of olap? Give an example?
Under what condition selecting sorted input in aggregator may fail the session?
What is aggregate cache in aggregator transformation?
Define enterprise data warehousing?
