Question: what is the difference between native sql and cognos sql?
Answer: In this way, Cognos SQL offers the most added value. Native SQL is the SQL the data source uses such as Oracle SQL. ... Pass-Through SQL query subjects are not processed as subqueries. Instead, the SQL for each query subject is sent directly to the data source where the query results are generated.