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
  • Attach files
  • Fajon Siew commented
    15 Jan, 2022 09:46am

    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.

  • Fajon Siew commented
    15 Jan, 2022 09:45am

    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/

  • Fajon Siew commented
    15 Jan, 2022 09:45am

    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/

  • John Munkberg commented
    3 Jan, 2022 07:22pm

    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)