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
- 7149 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
generate date / time dimension in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is meant by pre and post session shell command?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Enlist the various types of transformations.
What is the difference between stop and abort in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is blocking transformation?
How many dimensions are there in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is song in infrmatica...?
If informatica has its scheduler why using third party scheduler?
What is the difference between a repository server and a powerhouse?
difference between repository database and repository service?
Can anyone tell me the new features in Informatica 9 Version?
