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.
Answer Posted / prabhas
In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
which one is better performance wise joiner or look up
Explain Dataware house architecture .how data flow from intial to end?
What is a predefined event?
What is substr in informatica?
What are the limitations of joiner transformation?
What are the features of complex mapping?
How would you copy the content of one repository to another repository?
Explain what are the different versions of informatica?
How to elaborate tracing level?
What is informatica metadata and where is it stored?
What is aggregate cache in aggregator transformation?
How to do the error handling of if ur source is flatfiles?
How to create Target definition for flat files?