Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

can any one say me exactly when and where alias and context
are used in resolving a loop.
If possible try to give me a scenario also.

Answer Posted / vams_gk

when a schema contains a loop u should create alias
table..alias concept not only for loops.we can also use
in fantraps.
coming to context :when u run two sql statements as a
singlestatemnt we will go for context detection process.

in traps we can choose contexts.
traps are two types chasam trap and fan trap.

these traps are situvation oriented
relation betwen muliple tables like this:
--------------------------------------0-

chasam trap :1:M:1
fan trap :1:M 1:M

really if u want o see the context how to look
tools->automatic detection----.detect contexts in BO XIr2

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between slice and dice and cross tab report?

1108


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3883


Explain what task is 98% of the required work of a business analyst?

1171


Explain about a task that really tested your analytical abilities?

1298


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2201


Explain what are the steps to do to use alerts in bo?

1126


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1055


Explain in detail about type 1?

1825


what is xcelsius architecture?

4637


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2329


What sort of existing documents should business analysts refer to when starting on a new project?

1059


Explain the difference between detect alias and detect context?

1137


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1155


Explain how to execute the plsql procedure from the report by clicking with mouse?

1089


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1915