Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am joining 3 tables in tMap (1 main + 2 lookup tables) and the target table needs to be updated.
One of the column in the target table is Total number of rows joined.
When TMap writes to Target Table, it is processed row by row. While writing to Target table I need to write total no. of rows joined also as one of the target column.
How can I acheive this? When it is getting written in the target it is row-by-row... but at the same time one of the column should be updated with the total-no-of matching rows.... I am not sure how to do this.. Any help please?