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 are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,


Can we create reports using OLTP database?How?

3 Answers  


What is RenderVariable?

5 Answers  


what use of surgate key in project

3 Answers   HCL, TCS,


How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,






What are Governer Settings?

2 Answers  


data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,


How can we improve performance in framework manager level?

3 Answers   Wipro,


Types of Performance Tuning?

2 Answers   CGI,


What is the difference between macros and prompt?

2 Answers   IBM,


What is portal page?

5 Answers   TCS,


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


Categories