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.
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 |
Whats there in global repository
What are the databases that informatica can connect to windows?
While importing the relational source defintion from database,what are the meta data of source U import?
What are the types of presistent cache in look up tr.
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Is it possible to define a single node as a Gateway node as well as worker node?
tell me the push down optimization
How are the sources and targets definitions imported in informatica designer?
what are challenges that you faced in testing? give solution to it?
what is the difference between informatica6.1 and infomatica7.1
What are the types of lookup transformation?
What aer the out put files that the informatica server creates during the session running?