Post reply

Data Flow Task

  • July 3, 2009 at 3:32 am

    #133653

    Can any one give anwsers to following questions

    What is difference between Union all and merge?

    What is Conditional Split and give its syntax?

    Thanks and Regards

    Qazi Mohd Haseeb

  • July 3, 2009 at 4:41 am

    #1019702

    What is difference between Union all and merge in sql server?

    Well both of them essentially takes outputs from more than one sources and combines them into a single result set but there are couple of differences between two:

    a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs

    b) Data has to be sorted before Merge Transformation whereas Union all doesn't have any condition like that.

    What is Conditional Split and give its syntax?

    http://msdn.microsoft.com/en-us/library/ms137886.aspx

    Tanx 😀

  • July 3, 2009 at 9:03 am

    #1019794

    thanks

    what is differents between FuzzyLookup and Lookup?

  • July 3, 2009 at 9:32 am

    #1019803

    Fuzzy is only allowed to be used in Enterprise and Developer versions.. And allows imprecise lookup operations where the text of a name "Rosie" might be matched to "Rose", in a lookup there is ONLY direct matching 1=1, 2=2..

    CEWII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply