Skip to Content
0
Former Member
May 24, 2013 at 02:23 AM

What is the difference between "p1.p2/MyView" and "p1.p2/MyView/hier/MyView" Generated Column Views?

65 Views

Hello Experts,

I am trying to understand the difference between the generated column views "p1.p2/MyView" and "p1.p2/MyView/hier/MyView", where p1 is the package, p2 is the subpackage, MyView is the view in package "p1.p2".

Please could some one let me know the technical difference between the two, when are they created and their significance? I noticed that "p1.p2/MyView/hier/MyView" generated column view is not created if the MyView doesn't have any columns identified as key attributes..

Thank you!

Regards,

Hema