For Table A there are 2 keys (X,Y) which I have to compare with that of Source. conditon for look-up this table is IF (Source.X=TableA.X) AND ((Source.Y=TableA.Y) OR (Source.Z=TableA.Y)) then get data from TableA.
For Table B there are 2 key (X,Y) which is simple i.e.:
IF (Source.X=TableB.X) AND ((Source.Y=TableB.Y) then get data from TableB.
Code: Select all
TableA TableB
(X,Y) (X,Y)
| |
| |
| |
V V
Source------->Transformer-------->Target
(X,Y,Z)
My question here is :1.What will be in Key expression in Left pan of Transformer for TableA.?
2.How key expression works ?
Thanks in advance.