Option to add a "DISTINCT" in the InsSel rule
There are times where we have source with Multiple records and we need only 1 of the unique record to be added into the tt from st. Currently we are modifying the InsSel rule to have the DISTINCT clause and have to keep track and make changes if there is change in Insert Statement. Providing a Check Box DISTINCT in the Target Source and AutoGen adding the DISTINCT in InsSel would address the manual intervention
-
Guest
- Dec 30 2021
- Needs review
Related ideas
If you’re going through a rocky period in https://dltutuapp.com/tutuapp-download/ your marriage, you may want to repair things on your own before taking the leap right to counseling.
However, keep in mind that certain issues do require a professional touch, and if your marriage feels like it’s still struggling after you and your spouse gave it a shot, you may need to reach out to a counselor for help. https://dltutuapp.com/tutuapp-download/
It can be intimidating to try and fix things yourself, but so long as you and your spouse work together, there’s no reason you can’t improve your marriage without professional help. https://showbox.run/
No - I do not believe we should support a DISTINCT on insert. You should set your zActive flags to mark duplicates as inactive. The only where clause on the insert from source to target should be based on relevant source records (i.e zActive = 1)