scenario

san_dwh · Post by **san_dwh** » Wed Feb 02, 2011 3:51 am

Hi DS guru's
I need your help in implementing a logic.
I have 2 source data sets with key columns. In the target, I need a flag variable have the column. My requirement is : If 2 sources have the records in key column,then in target flag variable column value should be 'Y' and if any one of or both the sources doesn't have the records, then in the flag variable column value in target should be 'N'.
How to implement this logic.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 4:54 am

Full outer join, set flag to 'Y' if both key values are not null.