Flag is not updating based on source/target comparison at tmap also giving postgres I/O error

[gt0731]

Hi team,

 I am trying to perform  SCD   using tmap component. In that, is_Active Boolean flag is not updating  the flag as expected. 

Here we are looking for flag change so that  we will identify old/new data based on this FLAG. 

Source - Excel file

Target  - Postgres

Getting following error from tpostgresourput component 

Here is complete error log 

Starting job stg_to_ps_fact_approved_yer at 18:39 12/05/2019.

[statistics] connecting to socket on port 3439
[statistics] connected
\
An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.An I/O error occured while sending to the backend.
[statistics] disconnected
Job. [exit code=0]

Any help on it would be much appreciated?

[Anonymous]

Hello,

 It looks like there is some issue at the DB end processing so much data at a time may be some configuration issue. Is there any network bandwidth problem or data transmission restrictions/limits?

Best regards

Sabrina