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
- 6994 Views
- I also Faced
- E-Mail Answers
Answer Posted / prabhas
In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
What is flashback table ? Advance thanks
How can we update a record in the target table without using update strategy?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the session task and command task?
Explain lookup transformation source types in informatica
What is aggregator transformation in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is native users?
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?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the new features of Power Center 5.0?
Could you explain what is enterprise data warehouse?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
how tokens will generate?
