Transformation Components

detect changes

Every time i validate the detect change component , an invalid identifier error pops up. How to fix this error

Update all table in one transformation job

Is it possible to perform table update transformation job on all tables from on schema to another.

Add Leading zeros in record

Hi, I have a transformation which loads data one to one from a view to a target. Now I have a column varchar(5). I want add leading zeros whenever record...

Add Leading zeros in record

Hi, I have a transformation which loads data one to one from a view to a target. Now I have a column varchar(5). I want add leading zeros whenever record...

Update query in SQL component

I'm trying to put an update query in a SQL component. Is that not supported? Even with very simple updates, the component won't validate, giving me an error: "Validation error....

Table Update component not inserting records

Hi Team, I am using Table Update component to insert my target table record, same transformation is working for other jobs without putting BEGIN/COMMIT component but for one orchestration job...

Filter on Boolean Data with Filter Component

I have extracted data from a SQL Server table, including a "Bit"-type column. Now, in Matillion, when I use a Table Input component to use that raw data, I have...

Filtering table using dynamic dates

Is it possible to filter a table in a transformation job using a dynamic date e.g. -2days ago from the runtime? I have tried putting "${dt.now().add("days", -2)}" into the value...

Date round in mongo db query component

I have a date field in utc format like '2017-06-02 16:39:35.843' how to round the date '2017-06-02 16:39:36' in mongodb query component advanced mode?

Use Grid column with an expression

Hello, I would like to understand if it is possible to apply an expression to a Grid column value when mapping it to a component property, similarly to applying a...