sunil

• Aug 8th, 2006

 

hi

  the difference between union and group is as follows:

take  two tables t1 and t2.

in t1 we have columnss like a,b,c,d. and t2 has a,d,e,f.

so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f

where as group performs on a indiviual column in a particular table.

Venkatachalam

• Aug 12th, 2006

 

Clearly explain the group with one example

Venkat

Reuben

• Aug 21st, 2006

 

If a table has 2 columns Gender and Name

Gender      Name

Male         Tom

Male         James

Male         Harry

Female     Jenny

Female     Fern

Tom, James and Harry belong to Group Male.

Is that any clear? 

sumanbalaram

 Profile Answers by sumanbalaram 

• Sep 2nd, 2006

 

union operation can be performed on basic cubes, remote cubes, ods objects, master data objects,infosets. i.e u can form union operation simultaneously on cubes, ods, master data objects, infosets. Multi provider does union operation.union operation can be performed on multi dimensional oblects.

                 But join operation is performed only on master data objects and Ods objects which are 2 dimensional. Infosets perform join operation.

   with regards,

    suman