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
- 7350 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 flashback table ? Advance thanks
Write the advantages of partitioning a session?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain pushdown optimization and types in informatica
Is it possible to create multiple domains on a single Informatica server?
How can repository reports be accessed without sql or other transformations?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain transaction control transformation in informatica
Explain how to import oracle sequence into informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is meant by active and passive transformation?
Partition, what happens if the specified key range is shorter and longer
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How can we use mapping variables in informatica? Where do we use them?
What is rank transformation in informatica
