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
- 6913 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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a joiner transformation and why it is an active one?
How do you use reject loader.
How many ways are there to do 'remove duplicate records in informatica'?
How do you load first and last records into target table?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What can we do to improve the performance of informatica aggregator transformation?
Differences between version 7.x and 8.x.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the function of union transformation?
Global and Local shortcuts. Advantages.
What is the maplet?
Define sessions in informatica etl?
What is Session and Batches?
Different sorts of metadata that stores in the storage facility?
