Hi everybody,
We have new requisition from our clients, we haven't done such mappings before in ODI (current version we use is 12.2.1), so we would appreciate any help :)
According to Data Source Mapping file we should create mapping with 3 source tables and 1 target table (containing 3 "id_source" columns of course). The tricky part is how to connect these 3 source tables, since we have some priorities or ranks here, for instance priority should take into account table1 - table2 - table3 (firstly, we take rows from table1, if there are not such rows then from tbl2, then tbl3...if we have some ID's contained in tbl2, but not in tbl1, such rows should be mapped respecting the priority tbl2 - tbl3 --> since there are no respective rows in tbl1). So, the question is how to "connect" these 3 source tables, and later link relevant columns to target table respecting the priority mentioned above. Thanks everybody in advance :D
Best regards, Mihajlo