what is a join? what are the types of joins?
- 5 Answers
- 8393 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / palzkumar
Both are right.. but slight changes... joins is used to
fetch the records/data item from two or more queries (no
tables in cognos) using
type of joins like...
1.EQUI / SIMPLE JOIN (eg. 1:1 = 1:n)
2.SELF JOIN
3.OUTER JOIN
a.left outer join (eg. 1:0 = 1:n)
b.right outer join (eg. 1:1 = 1:0)
c.full outer join (eg. 1:0 = n:0)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How is possible this scenario using in type-in prompt.?
What do you understand by the term 'aggregate advisor?'
Can you define drill down and drill up?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What are query items?
2. What functional area you worked on.
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What are the other methods working as deployment functionality?
Can you define query studio?
Give me any example of semi and non additive measures?
What do you understand by ‘ibm predictive maintenance and quality’?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
how can you get the errors in job? when loops are araised we get error?
------------------What is Inline Query?
Which studio is used to create reports?
