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
- 7169 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 join three sources using joiner?
What is the need for an etl tool?
What is the function of aggregator transformation?
Explain direct and indirect flat file loading (source file type) - informatica
How big was your fact table
What are the types of data warehouses?
What is enterprise data warehousing?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Where can we find the throughput option in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Target increases every day even though no new record was inserted
Which version configuration tool used in ur project?
Explain the aggregator transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
