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 |
what are slowly changing dimensions? Why we are used scd?
Can we create reports using OLTP database?How?
What is RenderVariable?
what use of surgate key in project
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
What are Governer Settings?
data import to models, datastores,stored processed, is there any other way to import data?
How can we improve performance in framework manager level?
Types of Performance Tuning?
What is the difference between macros and prompt?
What is portal page?
can you tell me what are the dimension tables are used in project