Transformation issues in tELTpostgresqlMap

gimgi69 — Fri, 15 Nov 2024 21:41:05 GMT

Hello,

I'm working on TOS 8 and on a postgre DB.

As i process a large volume of data, I converted the "classical" tMap and tdbInput into tELTpostgresqlInput / tMap / Output .

I save a lot of loading time this way !

BUT huge problem

My simple transformation into the tMap doesn't work anymore into the tELT map and this is a huge problem.

For example :

output1 in the expression editor :

input1.amount == null ?

input1.total:input1.amount

But it's doesn't work --> the logging error is : missed the first parameter

Did you already encoountered a similar issue with an ELT component ?

Thanks by advance for your help!!

Re: Transformation issues in tELTpostgresqlMap

Anonymous — Thu, 15 Jun 2023 03:02:37 GMT

Hello,

Do you have different connections for Input with tELTpostgresqlMap? As the tELTXXXMap has option to get only one connection and ELT works when you are going to process the transformation rules after loading the data. Could you show your job design and component setting?

Best regards

Sabrina

topic Transformation issues in tELTpostgresqlMap in Talend Studio

Transformation issues in tELTpostgresqlMap

Re: Transformation issues in tELTpostgresqlMap