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?



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

Answer / 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

More Cognos Interview Questions

What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,


how to connect datamarts

0 Answers   HCL,


How to create a cube in Transformer? What is the process? Please mention process thank u

0 Answers   Genpact,


Tell me about Dnamic and Static Dashboards?

0 Answers  


What is a Transformer?

0 Answers  


Can you define pivot?

0 Answers  


how to convert crosstab into list?

4 Answers   TCS,


----------------What is meant by DSS?

1 Answers   Bank Of America,


3. What was the size of your cube?

1 Answers   IBM,


what is the difference between list sequel and cross tab sequel?

2 Answers  


In framework Manager, what is a stitch query and is it good or bad?

2 Answers   Polaris,


Explain the difference between native sql and cognos sql?

0 Answers  


Categories