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
- 7352 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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the scenario which compels informatica server to reject files?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Clarify the utilization of aggregator cache record?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Scheduling properties,whats the default (sequential)
Write the prerequisite tasks to achieve the session partition?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is target designer and target load order?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does cheating measurement mean?
pmscmd startworkflow -sv
Explain why we use partitioning the session in informatica?
Tell me about MD5 functions in informatica
What is lookup transformation?
