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
