Advanced

Manifest strategy

Hi, As an example - I have an account table and I have to use a Manifest strategy to load data. Assume Manifest file has one entry today wrt Account....

API Generator Properties

The last input box on the API generator form is labeled Properties. How do I translate my authorization header into the correct syntax? <rsb:set attr="Header:Name#" value="Authorization" /> <rsb:set attr="Header:Value#" value=...

java

where are the java logs

Job scheduling order

Hi, I have created one master matillion job that references various matillion jobs to load the data into redshift. Start---> (1)Matillion Orch Job that creates 10 stage tables and S3...

Load strategy

Hi ! I have two schemas - stage and target. I have two table. Test_Stage and Test_Target. Columns - (Yearmonth,Code,Revenue) Here is Test_target table data. 201702 10 500 201703 20...

Job Status Messages

Hello ! We have Matillion jobs designed in a sequential manner as shown below. 1) create stage dim tables and load them from S3 bucket 2) create target dim tables...

Nodata Input object and load time

Hi ! There are two scenarios. 1) In orchestration job, you have an input file- Product.txt which is totally empty. It has no data. No column names either. I have...

Iteration in API Profile's RSD Language

Hi all, Reading through the CData's RSD:scripting docs: http://cdn.cdata.com/help/DWA/jdbc/pg_items.htm, it seems to be a very powerful way to interact with various API to extract data. Is there any documentation how...

Checks before Truncate and Load

Hi, I have an empty data file ACCOUNT.txt. I have a Matillion job that creates ACCOUNT_STAGE table and then loads the ACCOUNT.txt from S3 bucket. Job - 1 I found...

Preparing a file for S3 load

Hi ! We have a Table called ACCOUNT. We generally receive a file in this format = ACCOUNT_UIP_20180201_161512.TXT What we do is - We first manually rename a file like...