Transformation issues in tELTpostgresqlMap

[gimgi69]

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!!

[Anonymous]

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