Answer / palzkumar

UNION is one of the set operator, which is to apply one or more queries, that results in a projection list on which other queries can be based.
JOIN is not a set operator, but it's used to joins two queries with various relationship's cardinality.

Answer / sharath.dwh

IN REPORT STUDIO JOIN IS USED TO JOIN TWO TABLES AND

UNION IS USED TO JOIN 2 REPORTS OR QUERIES.



SHARATH

How to create a cube in Transformer? What is the process? Please mention process thank u

1 Answers   Genpact,

---

What is a query set?

3 Answers   IBM,

---

what is the meaning of drill down and drill up in COGNOS 8BI

3 Answers  

---

Explain is there any comparison available for cognos reportnet vs crystal reports?

1 Answers  

---

What is meant by drill down?

1 Answers  

---

what was the actual purpose of portfolio in cognos ?

1 Answers  

---

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

---

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

---

what is boxtype

1 Answers   IBM,

---

How many fact tables you have in your project?

1 Answers   HCL,

---

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1 Answers   iFlex,

---

difference between boxtype and visiable

1 Answers   IBM,

---