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
- 6396 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
what are the deliverables?in your project?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
tell me about your project functionality
What is dimensional table?
differences between service based and product based?
Explain in detail scd type 2 through mapping.
What is target load order?
What is different between the data warehouse and data mart?
what is the Default Source Option For Update Strategy Transformation?
What is the format of informatica objects in a repository?
How we can create indexes after completing the loan process?
Write the advantages of partitioning a session?
