Untitled

 avatar
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...