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
- 7148 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ramana
we need two pipelines in mapping.In first pipeline,take expression trans,create one port with date type and assign sysdate to it.After drag this port to target file.
In the second pipeline load the source record into target file.But here we need to select APPEND IF EXISTS option.Both pipelines we need to give same file name.
| Is This Answer Correct ? | 0 Yes | 0 No |
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
why we need informatica
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
What is up date strategy and what are the options for update strategy?
Can we change Dynamic to Static or Persistent cache? If so what happens?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
what is diff between IN and EXIT commands
How do you change parameter when you move it from development to production.
in which situations do u go for scds ?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
How Union Transformation is an Active Trans?
While importing the relational source defintion from database,what are the meta data of source U import?
Teradata 
