SAP Data Services – Query Transform

  • Propose Join can be used to join two or more tables, only possible if we have more than one input schema

19

  • GROUP BY:
    • The GROUP BY tab is used to specify how the output rows are to be grouped (if required).
    • Once maintained, it applies to all the output Columns.

20

  • ORDER BY:
    • The ORDER BY tab is used to specify how the output rows are sequenced (if required).
    • Once maintained, it applies to all the output Columns.

21

  • ADVANCED:
    • ADVANCED tab is used to specify, if the user wants to run a separate process for different operations
    • The separate process option is made available for below operations
      • DISTINCT
      • GROUP BY
      • JOIN
      • ORDER BY

22

  • Find:
    • Find tab is used to locate input and output elements containing a specific word or term.
    • Find tab also have the different options to refine the search item, like
      • Schemas

26

  • Elements

25

  • Where

24

  • Match Case

23

With this we have seen in detail about Query transform and different Properties of available for us.

Thank you for reading and hope this information is helpful. Please do share with your friends if you feel the information is useful.

Happy Learning.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

ten + 7 =