Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?
Answer Posted / krishna tammana
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can you define folder?
What is Metrics designer?
Explain is there any comparison available for cognos reportnet vs crystal reports?
Can you define pivot?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What is meant by Reportstudio shortcut?
How to create model and how to test model?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
what is the difference between native sql and cognos sql?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What is a Query Subject?
how to create cubes in transformer ?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
dumps needed ASAP for - C2020-180 Cognos IBM Certification