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
- 7161 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
What is rank transformation in informatica
design of staging area?
What are mapplets? How is it different from a Reusable Transformation?
In development project what is the process to follow for an etl developer from day1
What is native users?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a stored procedure transformation?
Why union transformation is an active transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How will the document be delivered to me?
What is status code in informatica?
How can we update a record in the target table without using update strategy?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Write the unconnected lookup syntax?
What is rank transform?
