Skip to main content
Solved

Is it possible to adjust the values of Table Handling (Use Existing or Truncate Existing) in a flow


scootercat_nl
Contributor
Forum|alt.badge.img+5

attribuut : Oracle Non-Spatial Writer

parameter : Table Handling (Use Existing/Truncate Existing)

 

Is it possible to adjust the values ​​of Table Handling (Use Existing or Truncate Existing) in a flow?

 

In a daily data dump, there can be a mutation file or an initial file per table (csv file).

Based on that I want to determine Table Handling.

 

This will save a lot of work. Now I still use 25 CSV files out of more than 100. This may increase in the future.

 

For example, of those 25 files, 5 can be initial files and 20 can be mutation files.

 

It will be written to Writer Oracle Non-Spatial.

For the Feature operations I use fme_db_operation.

 

I hope my question is clear.

 

Thanks in Advance

Best answer by nielsgerrits

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.

View original
Did this help you find an answer to your question?

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • October 19, 2023

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.


scootercat_nl
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • October 23, 2023
nielsgerrits wrote:

You can set this using a parameter, not using an attribute. If you use a workspacerunner in a parent workspace you can start the child workspace to process a file using the parameter set for table handling.

thanks for your good tip


nielsgerrits
VIP
Forum|alt.badge.img+54
scootercat_nl wrote:

thanks for your good tip

cheers :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings