date

[kpmINFO]

I have a flat file source with date format dd-mon-yyyy
I would like to transfer this into oracle table column (Date datatype)
How can I get it.

I tried assesing the flat file date fiels as "String" , using expression tr I used To_Date function to convert into date [to_date(Date_port, 'dd-mon-yyyy') ] this function is returning a viered date.
Can some one help me achieve this
I would like to transfer the date as it it
My source file conatin date "dd-mon-yyy" format and I would like to transfer this into oracle target as it is "dd-mon-yyyy".
I am using informatica 6.2

 

[sln007]

kpm,

My flat file data input is a number of 8 digits.
If field is not = 0, it is in the format YYYYMMDD.
The following tr is what I used to target Oracle:
TO_DATE(TO_CHAR(PAY_PERIOD_END ) , 'YYYYMMDD')

I haven't tried too many different formats yet for dates.
I'll attempt to do a couple tests to see if I can help you.
We're just now upgrading to 6.2. So it may be a couple
days.

 

[ClaireHCM]

You can call a expression transformation. Pull the date string from flat file.Change the input port name to IN_Date.
Uncheck the output port of IN_DATE

Add a new output port called "Out_DATE" in the expression transformation, set it date/time datatype. Define it as TO_DATE(IN_Date,'dd-mon-yyyy')

Pull the OUT_DATE into the target table.