Hi Misra,
Option: 1
Introduce an additional attribute, for each of the data sources that have the same value-based say 1 for each source system. Configure SRC_SYS and have a fallback with LUD.
Option: 2
For both data sources,
1. Have the common source system name and add your specific source name under crosswalk.table
2. Configure Source System Survivorship and have fallback as LUD for that attribute
This approach should work with other data sources including those 2 and can have more attribute-specific survivorship.
Analyze the pros and cons for each approach based on your other data sources and requirements.
------------------------------
Radhakrishnan Ramalingam
Architect
San Ramon CA
------------------------------