DSXchange

Hi,
I have getting below two warnings.

1.summary_file,0: Bad trailing quote character at field "Date"; looking for '34' but found 'r', at offset: 11

2.getting import error for the below field, for the field data type is date,size is 10 and using pipe delimeter as field delimeter.

date format :: 20121101

Please could any one help in this case

MYDAS,0: Field "BaseLine_Date" has import error and no default value; data: {2 0 1 2 1 1 0 1 | V}, at offset: 74

Post some input records and detail for us the settings you are using in the Sequential File stage.

Your default date format is ten characters (YYYY-MM-DD) but the dates in your data contain only eight characters (YYYYYMMDD). You need to adjust your metadata, specifically the format for that date column.

Hi,

Input record format in sequencial file

Data type :: Date
Length ::10
record ex :: 20110101, 20120606 YYYYMMDD

field delimeter is ::: pipeline

I need to pass same value into output

Why don't you read it as char and transform it later in transformer.

deesh wrote:record ex :: 20110101, 20120606 YYYYMMDD

This is a complete and accurate example of a record from your file? It actually includes the "YYYYMMDD" part? You've also said the field delimiter is a 'pipeline' by which I assume you mean pipe or '|' and yet there is not such character in your example and it doesn't match either error.

You still have to set the date format string in your metadata to "%yyyy%mm%dd" - you have provided no evidence that you have done so.