Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 26525 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thakkalapelly anil
cognos sql is most prefarable because it can fetch the data
from multiple databases.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / akhilesh pyasi
Cognos SQL because it improved performance of query by
converting simple sql to optimum Cognos Sql.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
(1)The FWM uses cognos SQL as a default SQL to create and
edit query subjects.
(2)cognos sql supports SQL 99 standards, which are used in
modifying the query subjects.
Where as
(1) The native SQL is the SQL the database uses such as
oracle,sql secver etc.
(2) A cognos query definition engine (QDE) convert the
cognos SQL into a native SOL which will be submitted to the
data source to query the data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sridhar
It depends upon the requirement of Report as well database .
If report wants to show from the different database cognos
sql is most prefarable because it can fetch
from multiple databases.
also for calculation as well other complicated business
rules Cognos sql its preferred.
also we can hide the underline tables as well database
source.
Advantage of native SQL will be no need of metadata .
We are passing the Query to native to handle it.
In my experince column name was case senstive if it changes
it was throwing error - isnt wiered :-(.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venu
cognos sql bcz cognos sql only adheres sql99 rules and work
with multiple datasources and query performance much
fasterthan native sql if we are using data from single
datasource native sql is preferable
| Is This Answer Correct ? | 1 Yes | 1 No |
what is session parameters? what is use?
What is model filter?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
In how many ways we can apply the security to a cube in Transformer? Explain?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
15. If I select the current month and year how can we display previous 11 months data?
Can you define framework manager?
What are the main services provided by application tier?
Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480
what is the role of cognos comsultant?what actually it means?pls reply
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
Teradata 
