can we join 2 different queries? One has 10 columns and
other has 5+ columns?

Answers were Sorted based on User's Feedback



can we join 2 different queries? One has 10 columns and other has 5+ columns? ..

Answer / the_xxx

yes you can join two diff queries based on common key data
item, you cannot union them ( for union both queries must
have similar data items and order of the items)..hope this
helps.

Is This Answer Correct ?    18 Yes 1 No

can we join 2 different queries? One has 10 columns and other has 5+ columns? ..

Answer / pavan kumar

Suppose if u have common column We use Master Detailed
RelationShip.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Cognos Interview Questions

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  


HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,


Can i apply drill through on master detail relationship report?

2 Answers   TCS,


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

0 Answers  


Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,






my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

1 Answers   IBM,


how to explain health care project and which reports we can create in health care doain?

0 Answers  


How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.

3 Answers   UHG,


-----------------What is Direct and Conventional loading?

0 Answers  


How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 Answers  


16. How can we create top 10 and bottom 10 records in the same list?

9 Answers   TCS,


Difference betwween cognos report net architecture and cognos8 architecture

3 Answers  


Categories