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.

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,

---

What is meant by report studio short cut?

2 Answers  

---

what is the difference between list sequel and cross tab sequel?

2 Answers  

---

What is a Framework manager?

0 Answers  

---

-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,

---

Explain the characteristics of cognos?

0 Answers  

---

what is fact less fact give me proper example?

2 Answers  

---

How can we improve performance in framework manager level?

3 Answers   Wipro,

---

What are the components used in web tier?

0 Answers  

---

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

0 Answers  

---

When we save a report in report studio with what extn it save?

0 Answers  

---

What are the advantages of using cognos sql?

0 Answers  

---