what is loop in frameworkmanager ?
Answers were Sorted based on User's Feedback
Answer / s.srinivas
A LOOP IS A CLOSED PATH IN FRAME WORK MANAGER DUE TO
JOINS.WE ILL RESOLVED IT BY CREATING ALLIAS AND CREATING
SHORT CUTS
| Is This Answer Correct ? | 7 Yes | 0 No |
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 |
Answer / shekar
loop is closed path in reportnet it called as ambigous
relation ship. that means a query subject contians
multipule paths to retrive the data
it is a exception to reslove to create a shortcut on that
query subjet
other wise it displys wrong results in reports and
perfomens is digreegs.
| Is This Answer Correct ? | 4 Yes | 1 No |
4. How many dimensions did you use in your reports?
What is stitched Query?
how many types of keys are there i.e primary key and foreign key etc..?
What is the difference between macro & Parameter
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
What is Online View?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
Can you define framework manager?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Why need staging area database for dwh?
Give me any example of semi and non additive measures?
What snowflake and Starschema?