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
- 7149 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 dynamic target flat file name generation in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to partition the Session?
What is persistent lookup cache?
How can you differentiate between powercenter and power map?
In informatics server which files are created during the session rums?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is joiner transformation in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to update or delete the rows in a target, which do not have key fields?
list out all the transformations which use cache?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the need of an ETL tool?
Write the different tools in the workflow manager?
How many ways a relational source definition can be updated and what are they?
