Interested to Buy Any Domain ? << Click Here >> for more details...
When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
- 2 Answers
- 7451 Views
- Rolta, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kumar
we have fourtables that is a,b,c,d. normally tables are connected a->b->c->d.I want to data like a->d at that time by using short cut join we can perform.A directly connected to D.
| Is This Answer Correct ? | 10 Yes | 2 No |
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to create Index to the table in the universe designer and how it improves the Query performence
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
how many micro cubes can a report can have
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
Can we do the slice and dice in webintellegence?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
What is the slice and dice?
WHAT IS INPUT CONTROL IN BO?
What is the difference between the public object&schema object?
How to hide objects or columns?
Teradata 
