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
- 6912 Views
- I also Faced
- E-Mail Answers
Answer Posted / aakansha
In expression write following if target field is defined
with DATE datatype:
TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'))
If target field defined with character datatype then use:
TO_CHAR(SYSDATE,'DD/MM/YYYY')
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the difference between Active and Passive transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the hint? how to use it to reduce the query processing in program?
Explain the features of connected and unconnected lookup.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the need for an etl tool?
How do you promote a non-reusable transformation to reusable transformation?
Clarify the aggregator change?
What is resilience time?
What are the mapping parameters and mapping variables?
What are the restrictions of union transformation?
what is the Default Source Option For Update Strategy Transformation?
What is deployment group?
