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
- 7171 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?
can anyone suggest best free Talend data integration training online
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you use reject loader.
What is confirmed fact in dataware housing?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to generate sequence numbers?
Briefly explain the aggregator transformation?
how to load dimension table and fact table. plz tell me the steps.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can u generate reports in Informatica?
What are the guidelines to be followed while using union transformation?
Explain sessions. Explain how batches are used to combine executions?
