Answer Posted / nasa
loop is nothing but closed path
it occurs when relation have like
table 1->relation with-> table 2-> relation with-> table 3-
relation with ->table 1.
here table 3 have the relation again with table 1 so simply
we can say here loop is occurred..
by using shortcut or alias we can resolve this...
table 1->relation with-> table 2-> relation with-> table 3-
relation with -> short cut table 1.
by right click on table we will get shortcut and alias
options..
shortcut: if we update or any modification in original table
that will effect on shortcut of that particular short table
alias: if we update or any modifications in original table
that will not give any effect on alias table
........
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
is there any difference between operational database and data base?if yes what r they?
What is meant by drill down?
What DB View and Bus View?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
---------------Describe OLAP Reporting and RDBMS Reporting?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
explain how to create powerplay reports?
What is drill down and slicing and dicing whats the difference between them?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What are the types of security?
which type of project we r going to snowflake schema
What do you understand by the term 'dynamic cube'?
What is the difference between a data mart and a data warehouse?
How to select multiple values from type-in prompt?