How to Update data based on mapping

AV2022 — Fri, 15 Nov 2024 21:48:17 GMT

Hello Team,

My requirement: I am trying to update the value in one of my Oracle output table based on the Input value from the Access DB.

Eg: Input Column has the below data

Column1 Column2 Column3 Column4

A B C D

My Expected output in Oracle output column should be based on Input value:

If the input value is A then output should be Anand

If the input value is B then output should be Boy

If the input value is C then output should be cat

if the input value is D then output should be dog

Output should have only one column and the data should be fetched on the mapping from the input table

Note: There are multiple Input Columns but single Output column.

I tried multiple ways to do this using tmap, but iam not getting how exactly i can do the mapping and generate the desired output with the help of expression builder. It would be great if u can help me with a solution.

Thanks

Anand

Re: How to Update data based on mapping

AV2022 — Tue, 16 May 2023 12:30:37 GMT

Hi Team,

Can someone help me with my above query.

Thanks

Anand

topic How to Update data based on mapping in Talend Studio

How to Update data based on mapping

Re: How to Update data based on mapping