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

what is a join? what are the types of joins?

5 Answers   HCL, Satyam,

---

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,

---

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,

---

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

---

any difference between cognos and real time cognos

0 Answers  

---

What do you mean by drill across?

0 Answers  

---

Is cognos models are version compatible?

2 Answers  

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---

Hi all, i have a requirement in Conditional drill through. I have a list report with Cities India, UK, USA, China, japan, Canada.... In the above cities i want to give Hyperlinks(Drill) for Only India & UK. Could you please send me the steps????

1 Answers  

---

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  

---

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

---