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.
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
How can you validate all mappings in the repository simultaneously?
What if the source is a flat-file?
How can we update a record in the target table without using update strategy?
What is event and what are the tasks related to it?
In which transformation you cannot drag ports into it?
What is meant by target load plan?
Can we get 1st record through Informatica(without sequence number).
What is decode in static cache?
What is aggregate cache in aggregator transformation?
Difference between Target-based loading and constraint-based loading?
What are junk dimensions?
How do you convert single row from source into three rows into target?
Write the prerequisite tasks to achieve the session partition?
Briefly define a session task?
What are the designer tools for creating transformations?