data load problem from teradata source to a dataset
Posted: Tue Jan 24, 2012 6:20 am
hi,
we are facing a wierd problem where we have a teradata source with 7000 records. the query used to retreive these records is user defined.
when these records are loaded to a dataset, the count is increasing to 200000.
in the source query there is a date condition mentioned as
DATE'#ps_FSR_R3P_DT_PARMS.XTRCT_DT#' where the date in parameterised is in format 'yyyy-mm-dd' which filters the data .
we suspect the problem around this.
can you please suggest the correct date format to be used when passing date as parameter.
we are facing a wierd problem where we have a teradata source with 7000 records. the query used to retreive these records is user defined.
when these records are loaded to a dataset, the count is increasing to 200000.
in the source query there is a date condition mentioned as
DATE'#ps_FSR_R3P_DT_PARMS.XTRCT_DT#' where the date in parameterised is in format 'yyyy-mm-dd' which filters the data .
we suspect the problem around this.
can you please suggest the correct date format to be used when passing date as parameter.