What is the difference between Native SQL and Cogn...
Cognos SQL:By default Cognos FWM uses Cognos SQL to create and edit Query Subjects. Contain metadata from multiple Data sources.
Native SQL :But we cannot use Native SQL in a Query subject that references more than one Data source in the Project. Contain metadata from single Data Source.
RE: What is the difference between Native SQL and Cognos SQL?
The Native SQL is what is being passed to the database. Where the Cognos SQL is the entire SQL used to perform the SQL. In certain scenarios the native SQL will be a subset of the Cognos SQL which may indicate that the application will do some local processing.
