Victor Gazquez

  • Total activity 68
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 12 users
  • Votes 28
  • Subscriptions 22

Posts

Recent activity by Victor Gazquez Recent activity Votes

  • [Collect] How to merge tables

    1. Community
    2. Tips & Tricks

    Solution: DSP Version: 6.6 Component: Collect and Assemble   I have recently worked in a request from the client that I would like to share with you as it has a few small functionality within Colle...

    • Victor Gazquez
    • Edited
    • 3 followers
    • 0 comments
    • 6 votes

  • [SQL] How to easily convert DATES

    1. Community
    2. Tips & Tricks

    Solution: SQL Server   In any migration project, the transformation of dates is a common task. There will be many occasions, when you will have to change the format to fit with the target requireme...

    • Victor Gazquez
    • Edited
    • 2 followers
    • 0 comments
    • 11 votes

  • [SQL] Case Sensitive and Collation Implication

    1. Community
    2. Tips & Tricks

    Solution: SQL Server   In addition to my previous post: https://support.syniti.com/hc/en-us/community/posts/360000812268--SQL-Search-for-patterns-and-Collation-implication I would like to add that ...

    • Victor Gazquez
    • 2 followers
    • 0 comments
    • 3 votes

  • [SQL] Search for Patterns and Collation Implication

    1. Community
    2. Tips & Tricks

    Solution: SQL Server Creation of reports where we need to search for characters, words or patterns is a very common task in any Data Migration project, or many others, where we need to do some data...

    • Victor Gazquez
    • Edited
    • 3 followers
    • 0 comments
    • 11 votes

  • [How To] Export Reports with Technical and Translated Column Headers

    1. Community
    2. Tips & Tricks

    Solution: DSP Version: 6.6 Component: Transform and Assemble   To generate target export reports with two headers, technical field and field description, you can use the Export Type = Local file to...

    • Victor Gazquez
    • Edited
    • 2 followers
    • 0 comments
    • 4 votes

  • Source Types

    1. Community
    2. Tips & Tricks

    Solution: DSP Migrate Component: Map   Do you know what the possible Source Types in dspMigrate are? Have you ever tried to delete a Source from Map and you couldn’t?   If you do not know the answe...

    • Victor Gazquez
    • 2 followers
    • 0 comments
    • 5 votes

  • [Automation] Considerations in 6.6.0 and 6.6.1

    1. Community
    2. Tips & Tricks

    Overview Among the new functionalities in release 6.6, there is one in particular that I want to bring to your attention as it is currently not working as expected. In 6.6, Report Auto Gen Level op...

    • Victor Gazquez
    • Edited
    • 1 follower
    • 0 comments
    • 3 votes

  • [How To] Add Help Text at the Column or Page Level

    1. Community
    2. Tips & Tricks

    Solution: DSP Version: 6.6.0 Component: Any Objective There are a few features in DSP that are not very common and which are not covered in the basic training courses. I am going to cover one of th...

    • Victor Gazquez
    • Edited
    • 2 followers
    • 0 comments
    • 3 votes

  • [How To] External Source

    1. Community
    2. Tips & Tricks

    Solution: DSP Version: 6.5 and 6.6 Component: Design and Map 1. Objective Prior to version 6.5, all Source Tables had to exist under the same database to be able to use them in Map. Since the versi...

    • Victor Gazquez
    • Edited
    • 6 followers
    • 1 comment
    • 5 votes

  • [How To] Advanced View Builder (AVB)

    1. Community
    2. Tips & Tricks

    Solution: DSP Version: 6.6.0 Component: Common and Collect WARNING: In DSP version 7.1, the Advanced View Builder in Collect stopped working.  This was fixed in the 7.1.3 release.   1. Objective Th...

    • Victor Gazquez
    • Edited
    • 7 followers
    • 3 comments
    • 7 votes