DSXchange

i am facing issues:
ecom_order_proj_dtl_SRC_SEL,0: Fatal Error: Virtual data set.; output of "ecom_order_proj_dtl_SRC_SEL": un-handled error converting output field.


source is orcale-->tranformer -->teradata.

while running the job ,it get aborted due to above issues.any suggest me ,how rwcoved the load.

Sure. Find out what's wrong with the data. It's something DataStage does not know how to handle. Check that the metadata in your job design precisely matches what you imported from Teradata.

source to target mapping is propere .this job is runing on daily bases.yesterday job got aborted ,perviouly it is working fine

Look at the stage, ecom_order_proj_dtl_SRC_SEL. there is possibly an implicit conversion. Check the data types for the source and the target columns and their mappings.

balu_infotech wrote:source to target mapping is propere .this job is runing on daily bases.yesterday job got aborted ,perviouly it is working fine

So what has changed? Tip: "nothing" is not the correct answer.

As I already advised, check the data.