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
- 7351 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
Explain the etl program with few examples.
What are the advantages of informatica?
Clarify the aggregator change?
Explain what are the different types of transformation available in informatica.
How do you load first and last records into target table?
Why update strategy and union transformations are active?
list out all the transformations which use cache?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is confirmed fact in dataware housing?
What is Index Caches size?
can you please explain me pre session and post session options?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Write the program through which the records can be updated?
Which transformation is needed while using the Cobol sources as source definitions?
Suppose we do not group by on any ports of the aggregator what will be the output?
