Problem with flat Files related to date field

[rkdatastage]

Hi

Can any one share me the knowledge how to handle date field extracting from flat files.

Here i am getting error like
"Transformer_3: ORA-01830: date format picture ends before converting entire input string"

Actullay my source is in yyyy-mm-dd HH:MM:SS.SSS
target table format is oracle format.

by the conversion functions i am getting the data converted into the format of oracle but it is throwing warning and data is not populating into target table

Thanks inadvance

RK

[rkdatastage]

Hi Folks

Can anybody share their idea about this problem

RK

[kcbland]

The autogenerated SQL puts to_date functions on your DATE or TIMESTAMP data type columns. If your data matches the format token in the SQL, everything works. I suspect your source data is ready to load, just verify. You won't have to do any DS functions to change the data.

[chulett]

DATE target field? Strip the milliseconds, they can't be stored in a DATE field.

[jojipjohn]

Try changing your datetype in the target stage to timestamp. If you don't want the "HH:MM:SS.SSS" part trim the source before loading it into the target.

[sb_akarmarkar]

You can also try TO_DATE of oracle function by writing user-defined SQL insert statement in target stage....


Thanks,
Anupam

[chulett]

The OCI stages will automatically generate the TO_DATE (or TO_CHAR) for the appropriate data types, no need for user-defined sql for something simple like that.

[sb_akarmarkar]

Can you check your OCI Stage genrated TO_DATE is it matching with "yyyy-mm-dd HH:MM:SS.SSS"....


Thanks,
Anupam

[ray.wurlod]

I think by now you are convinced that it's an Oracle problem, not a problem with accessing flat files.