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

can we create master detail report where master and detailed container is separate?

2 Answers   JPMorgan Chase,


What junk dimension contains?

0 Answers  


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

0 Answers   HCL,


Define query items?

0 Answers  


dumps needed ASAP for - C2020-180 Cognos IBM Certification

0 Answers   Aptech,


What are the different types of important services used in cognos?

0 Answers  


Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,


Give me any example of semi and non additive measures?

0 Answers  


Can you define a query subject?

0 Answers  


Usage of Stored Procedures in Cognos

1 Answers   General Motors GM, TCS,


While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,


-------------How to create a PortalTab?

1 Answers   Cap Gemini,


Categories