You are Here: ://SAP Data Services – Query Transform

SAP Data Services – Query Transform


  • Once we press finish, the pop up disappears and the SQL is shown in the space.
  • Apply is used to check if the written code is error free.


  • Smart Editor is similar to that of functions used to build Expressions.


    • SELECT is used to specify whether to output only distinct rows discarding any identical duplicate rows.


  • FROM:
    • FROM is used to lists all Input schemas.
    • Join pairs is used to specify join pairs and their joining conditions
    • We can even mention the join rank and can set cache for each input schema.
    • The resulting SQL will be displayed in FROM clause.


  • WHERE:
    • Where is used to specify filter conditions that determines which rows are transferred to output.


  • We have to mention our conditions in SQL syntax, similar to that of a WHERE clause in a general SQL SELECT statement
  • Ex: SAL > 800 AND REGION = ‘SOUTH’
  • We can also make use of Functions, Domains, and smart editor buttons to build our expressions.




Please proceed to next page to continue reading…


By | 2017-08-14T21:50:54+00:00 November 12th, 2015|Data Services|0 Comments

Leave A Comment

2 × 1 =

Skip to toolbar