Help need for this to avoid the Warning Messages
Posted: Fri Dec 09, 2011 2:23 pm
Hi,
I have source File which is flat file i am getting some warning messages;
Please some one can hel me out
source: falt file
delimiter: |(Pipe)
Final delimiter: None
Source as follows:
CUSTOMER_ID|CUSTOMER_NAME|TRANSACTION_DT|STR_DT,END_DT
1|UMA|1/1/2010|5/20/2010|12/20/2010
1|UMA|5/28/2010|5/20/2010|12/20/2010
Metadata definitiions:
Col Name Type Lenth Nullabale
CUSTOMER_ID integer 10 n
CUSTOMER_NAME varchar 10 n
TRANSACTION_DT date 10 n
STR_DT date 10 n
EMD_DT date 10 n
My logic is to filter the Transaction date between STR_DT and END_DT
My issue was, when i load the metadata definitions in sequention file and try to view the data. I am unable to view the data. It gives following error:
##W IIS-DSEE-TFIG-00198 14:00:04(000) <Sequential_File_0,0> Field "TRANSACTION_DT" delimiter not seen, at offset: 16
##W IIS-DSEE-TOIX-00154 14:00:04(001) <Sequential_File_0,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 14:00:04(002) <Sequential_File_0,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFRS-00051 14:00:04(003) <Sequential_File_0,0> Missing record delimiter "\n", saw EOF instead
##W IIS-DSEE-TOIX-00154 14:00:04(004) <Sequential_File_0,0> Import warning at record 1.
##W IIS-DSEE-TFIG-00198 14:00:04(005) <Sequential_File_0,0> Field "TRANSACTION_DT" delimiter not seen, at offset: 16
##W IIS-DSEE-TOIX-00154 14:00:04(006) <Sequential_File_0,0> Import warning at record 1.
If i change the datatatype for Date fields as below:
Col Name Type Lenth Nullabale
CUSTOMER_ID integer 10 n
CUSTOMER_NAME varchar 10 n
TRANSACTION_DT varchar 10 n
STR_DT varchar 10 n
EMD_DT varchar 10 n
Now i can view the data in the sequential file. But i need to implement a logic in filter stage as below:
TRANSACTION_DT between STR_DT and EMD_DT
Here as i read the date fileds as varchar i am unable to implement the above Logic.
Please cna anyone help me on this
I have source File which is flat file i am getting some warning messages;
Please some one can hel me out
source: falt file
delimiter: |(Pipe)
Final delimiter: None
Source as follows:
CUSTOMER_ID|CUSTOMER_NAME|TRANSACTION_DT|STR_DT,END_DT
1|UMA|1/1/2010|5/20/2010|12/20/2010
1|UMA|5/28/2010|5/20/2010|12/20/2010
Metadata definitiions:
Col Name Type Lenth Nullabale
CUSTOMER_ID integer 10 n
CUSTOMER_NAME varchar 10 n
TRANSACTION_DT date 10 n
STR_DT date 10 n
EMD_DT date 10 n
My logic is to filter the Transaction date between STR_DT and END_DT
My issue was, when i load the metadata definitions in sequention file and try to view the data. I am unable to view the data. It gives following error:
##W IIS-DSEE-TFIG-00198 14:00:04(000) <Sequential_File_0,0> Field "TRANSACTION_DT" delimiter not seen, at offset: 16
##W IIS-DSEE-TOIX-00154 14:00:04(001) <Sequential_File_0,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 14:00:04(002) <Sequential_File_0,0> Import unsuccessful at record 0.
##W IIS-DSEE-TFRS-00051 14:00:04(003) <Sequential_File_0,0> Missing record delimiter "\n", saw EOF instead
##W IIS-DSEE-TOIX-00154 14:00:04(004) <Sequential_File_0,0> Import warning at record 1.
##W IIS-DSEE-TFIG-00198 14:00:04(005) <Sequential_File_0,0> Field "TRANSACTION_DT" delimiter not seen, at offset: 16
##W IIS-DSEE-TOIX-00154 14:00:04(006) <Sequential_File_0,0> Import warning at record 1.
If i change the datatatype for Date fields as below:
Col Name Type Lenth Nullabale
CUSTOMER_ID integer 10 n
CUSTOMER_NAME varchar 10 n
TRANSACTION_DT varchar 10 n
STR_DT varchar 10 n
EMD_DT varchar 10 n
Now i can view the data in the sequential file. But i need to implement a logic in filter stage as below:
TRANSACTION_DT between STR_DT and EMD_DT
Here as i read the date fileds as varchar i am unable to implement the above Logic.
Please cna anyone help me on this