Ask Your Question

How to add fields(columns) with constant value for all records at the start of data?

asked 2020-07-21 16:12:44 -0500

amnopro gravatar image

I am using JDBC multitable consumer as my origin and Local FS as my destination. I want to add a column with constant value at the start of data. Before actual data columns. I know that we can use expression evaluator, but Expression evaluator is writing actual data columns first, No matter what order I specify in the expressions. Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-07-21 16:18:55 -0500

iamontheinet gravatar image


Look into using Field Order processor right after Expression Evaluator.

Cheers, Dash

edit flag offensive delete link more


Using field order processor, I have to manually define order for each table I am going to query. It is not possible as I have many tables.

amnopro gravatar imageamnopro ( 2020-07-22 15:24:27 -0500 )edit

using Oracle CDC client, I am looking for changes on multiple tables, So, I cannot use field order processor.

amnopro gravatar imageamnopro ( 2020-07-22 15:25:22 -0500 )edit

Well, AFAIK, there's no other way to force field order :-|

iamontheinet gravatar imageiamontheinet ( 2020-07-22 15:50:08 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-21 16:12:44 -0500

Seen: 391 times

Last updated: Jul 21 '20