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
- 7115 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramana
we need two pipelines in mapping.In first pipeline,take expression trans,create one port with date type and assign sysdate to it.After drag this port to target file.
In the second pipeline load the source record into target file.But here we need to select APPEND IF EXISTS option.Both pipelines we need to give same file name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
What happens when a session fails and you click on recover?
How do you change a non-reusable transformation to reusable transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is event and what are the tasks related to it?
What are the differences between oltp and olap?
What is the difference between source qualifier transformations source filter to filter transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How do we call shell scripts from informatica?
Where is metadata stored?
What is the status code in stored procedure transformation?
Write the prerequisite tasks to achieve the session partition?
What is an active transformation?
What are the tuning techniques you applied during your last project
What are different types of transformations available in informatica?
