data load problem from teradata source to a dataset

[hemaarvind1]

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.

[ray.wurlod]

What's the actual error message? "a wierd problem" (however you spell it) is not useful for diagnosis. You might also post the SQL used, as your fragment just looks plain wrong.