Untitled
unknown
plain_text
a year ago
1.0 kB
2
Indexable
SC,SERVICECATALOG,PPM_ANSF_RESPONSE_EVAL,ANSF_RESP_EVAL_ID,PPM_ANSF_RESPONSE_EVAL_SEQ,MASTER,panre,,panre.op_id='%s' AND panre.bu_id='%s',"op_id, bu_id",notApplicable,Y,,,,,,,,ETL_PC_ADMIN,SC,SERVICECATALOG,PPM_ANSF_RESPONSE_EVAL,PPM_ANSF_RESPONSE_EVAL_SEQ,MASTER,panre,,panre.op_id='%s' AND panre.bu_id='%s',"op_id, bu_id",notApplicable,Y,,,,,,,,ETL_PC_ADMIN in the above is the csv where below is the source SC,SERVICECATALOG,PPM_ANSF_RESPONSE_EVAL,ANSF_RESP_EVAL_ID,PPM_ANSF_RESPONSE_EVAL_SEQ,MASTER,panre,,panre.op_id='%s' AND panre.bu_id='%s',"op_id, bu_id",notApplicable,Y,,,,,,,,ETL_PC_ADMIN and below one is target data SC,SERVICECATALOG,PPM_ANSF_RESPONSE_EVAL,PPM_ANSF_RESPONSE_EVAL_SEQ,MASTER,panre,,panre.op_id='%s' AND panre.bu_id='%s',"op_id, bu_id",notApplicable,Y,,,,,,,,ETL_PC_ADMIN if you observer carefully ANSF_RESP_EVAL_ID is missing in target but its actually there in target db its actually primary key column but iam getting like that in above not only this every data is missing primary key in target
Editor is loading...