In Cognos Data Manager SQL Term or SQL Helper is used to create and execute SQL Queries or database Queries. Where as SQL TXT designer is used to define the structure of a flat file to load it in database or another destination (flat files).
Difference Between SQL TXT and SQL Term
Cognos Data Manager SQL Helper or SQL Term: This article is about what SQL Term and SQL Helper is and How to use them inside Cognos Data Manager.
