BIGINT expects and integer and 95139.81653861178 isn't an integer. You'll need a different data type that matches your source data better. You might want to try Schema Conversion Tool to help you. https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.ToPostgreSQL.html
Thanks for your help. I have changed postgres data type to double precision and it resolved the issue.
DMS load from Oracle NUMBER(38) to Aurora Postgres BIGINT fails although all values < 2,000,000,000asked 7 months ago
does AWS DMS support partition tables from postgresasked 8 months ago
ERROR: invalid input syntax for type bigint: "95139.81653861178"
Oracle materialized view replication to postgres using DMS CDCasked a month ago
Refactoring from Oracle to postgres, Do I need to drop foreign key constraitns at postgres
DMS Support for mapping rules - dynamodb-map data typeasked a month ago
How can I migrate a jsonb column from postgres on RDS to S3?asked a month ago
Error using Aurora Postgres version 11.8 as DMS source endpointasked 2 years ago
Using DMS CDC for Oracle to Postgresasked 2 months ago
AWS DMS Postgres to OpenSearch LOB handlingasked 7 months ago