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
Define enterprise data warehousing?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the differences between joiner transformation and source qualifier transformation?
Explain lookup transformation in informatica
How do you change a non-reusable transformation to reusable transformation?
What is the sequence generator transformation in informatica?
Why update strategy and union transformations are active?
Explain lookup transformation source types in informatica
How to update a particular record in target with out running whole workflow?
How to elaborate tracing level?
What are the data movement modes in informatica?
What is blocking transformation?
What is the benefit of session partitioning?
What is a surrogate key?
What are the settings that you use to configure the joiner transformation?