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...

how to create relationship between emp and salgrade tables
in frameworkmanager?

Answer Posted / suresh

Hi,
create one datasource query subject in FM. and write a sql
like
select emp.name,emp.salary from emp,salary_grade
where emp.salary between salary_grade.low_salary and
salary_grade.high_salary.

this is called non equal joins. like this you can create
relationship between this two table.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is main advantage datawarehousing over oracle?

1038


Can you define set to be cardinality?

1058


Define metrics studio?

1081


Can you define a datastore in cognos?

1072


how u will determine the performence tune will occur either in report or system

2178


What is a Query Subject?

1139


What is a Datastore in Cognos?

1339


What are all the types of report?

1134


What are the message flows?

1021


Explain is there any comparison available for cognos reportnet vs crystal reports?

1002


What is Metrics designer?

1079


what do u mean by bridge group? where we r using this one?

2041


How to a create header dynamically in a crosstab report in cognos 8.1?

2476


What is called materialized view?

1132


what is the main advantage of impromptu over cognos reportnet?

1087