Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajasekhar
hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is the difference between condition & filter?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is the difference in creating filters in designer and business objects?
Explain what three things do you consider to be the most important factors for a manager?
What is aggregate table and aggregate fact table ... Any examples of both?
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
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How can you first report in Business Objects by using broadcast agent?
Explain what are the steps to be taken to schedule the report?
Difference between b.o 5.1 and 6.1b?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what is aggregate table and aggregate fact table ... Any examples of both?
