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 |
Can you define a datastore in cognos?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
7. What is performance tuning?
How to connect three fact tables?
11 Answers L&T, TCS,
Define metrics studio?
What actually a project contains?
What is a scope? can you tell me one example for scope?
How can we create a dynamic column name in cognos?
Explain informatica architecture?
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
What is the information present in the cognos configuration file?