1. Home
  2. Misc
  3. SISS interview questions
  4. What are the differences between union all and merge operation in SISS?

What are the differences between union all and merge operation in SISS?

devquora
devquora

Posted On: Apr 01, 2020

 

Few differences between union all and merge operation in SISS are

MergeUnion all
Data that is stored in two different paths can be merged into one using the Merge optionUnion all is also used to merge two or more data from different paths into one
Before executing, sorting transformation should be applied. This helps to sort the data before mergingSorting transformation is not required for union all functions
The metadata of this type should be the same for all dataIn union, all option, all data from different sources are transformed and then is displayed as a single set.

    Related Questions

    Please Login or Register to leave a response.

    Subscribe Our NewsLetter

    Never Miss an Articles from us.

    Recent Articles
    Featured Categories

    Related Questions

    SISS interview questions

    Name the important components of the SISS package

    The components in SISS include the data flow, control flow, package explorer and event handler. All of these components come in the package after installing the SISS application from Microsoft. Other ...

    SISS interview questions

    Tell about the SISS package

    The SISS package is available for installation online and it is an organized set of connections. These connections include event handlers, data flow elements, control events, variables, parameters, an...

    SISS interview questions

    What is the type of containers that can be used in the SISS package?

    Containers are helpful in grouping different tasks together. Each one of them has a purpose that helps in performing various tasks. Here is a list of containers.Loop containersWhen we have to ...