Hallo Denodo Team,
Suppose you need to join tables from different data sources (say Oracle and Teradata). Suppose the matching should happen between attributes that have different data types (say VARCHAR(N) on one side, NVARCHAR(m) on the other side, or in the worst case NUMBER(N) on one side, CHAR(M) on the other). Suppose the values contained in that attribute provide a "meaningful match" (like 123 and "123").
Would such join be successful, or would the difference in data type be fatal?
Should I apply conversion functions in the where condition? How badly would this affect performance?
Thank you in advance