Multiple Postgres DB
- 2 months ago
Some of the observations here:
1. Data coming from upstream systems was messed up
2. There were added spaces in the data from the upstream systems itself
3. Ideally, with snapLogic, it should have been able to trim the spaces and help with the transformations however it wasn't able to do so
4. Having said that, the mapper and conditional snap works just right for other set of data so giving the benefit of doubt to the messy data coming from upstream systems.
Some recommendations/suggestions:
1. If you're using a csv file, please ensure the encoding is supported in snapLogic and select the encoding accordingly
2. For excel files, it should work just right
3. For data coming from upstream systems like Oracle, Salesforce or Snowflake, try to export the data and see if there are any discrepancies, if there are, align with your team internally to fix it before connecting it with snapLogic.
Closing this thread now.