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
- 6394 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
What is a node in Informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What you know about transaction control transformation?
Separate from an archive server and a powerhouse?
Explain sql transformation in script mode examples in informatica
What is a repository manager?
Define joiner transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is the size of u r source(like file or table)?
What is joiner transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Different circumstance which drives informatica server to expel records?
How to join three sources using joiner?
Can u generate reports in Informatica?
Difference between Target-based loading and constraint-based loading?
