Answer Posted / samir kumar sahoo.
A LOOP IS NOTHING BUT A CLOSED PATH DUE TO JOINS IN FRAME
WORK MANAGER. THE JOIN CONSISTS OF ATLEAST THREE TABLES.
THIS PROBLEM CAN BE RESOLVED BY USING ALIAS OR SHORT CUTS.
THE LOOP GENERALLY DEGRADES THE PERFORMANCE BECAUSE IT TAKES
MORE EXECUTION TIME AND DISPLAY WRONG RESULTS DUE TO A
NUMBER OF JOINS.SO WE BETTER TRY TO AVOID USING OF LOOPS IN
FRAME WORK MANAGER TOOL.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do you understand by the term 'aggregate cache'?
what is the procedure for scheduling conditional rendering?
what is the difference between native sql and cognos sql?
how to perform single sign in cognos by using url?
How to do Performence Tunning in Cognos Reports?
Define query studio?
Can you define set to be cardinality?
What do you understand by ‘ibm predictive maintenance and quality’?
What do you understand by the term 'dynamic cube'?
Define olap designer?
What r the names of the reports that you prepared?
How can you link a query to a data container manually in Report Studio?
how to connect datamarts
Define query items?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin