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

What are all the types of indexes in Cognos?

0 Answers  


what happens when date function has taken as attribute

1 Answers   TCS,


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

0 Answers   Wipro,


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  


In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  






is there any difference between operational database and data base?if yes what r they?

0 Answers  


What is Merging, Segments and porting in Framwork Manager?

3 Answers   Nike,


How many number of cubes can we create on a single model? How can we navigate between those cubes?

2 Answers  


if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 Answers  


4. How many dimensions did you use in your reports?

0 Answers   IBM,


How to hide value prompt box and list when run report?

4 Answers   IBM,


Can i apply drill through on master detail relationship report?

2 Answers   TCS,


Categories