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 METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,


What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?

1 Answers   IBM,


What is cognos reporting tool?

0 Answers  


Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  


What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,






i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,


What is the information present in the cognos configuration file?

0 Answers  


what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,


Write various indexes used in cognos?

0 Answers  


What do you understand by the cognos?

0 Answers  


What are the types of studio present in Cognos?

0 Answers  


what is the difference between group and association?

5 Answers   IBM,


Categories