what is a join? what are the types of joins?
Answer Posted / arkchowdary
Join----------------- Ajoin is fetch the data 1 or more
tables this is known as join.
Types of Joins-------------- Equi Join,
Nonequi join,
Self Join,
Cartesoin Join,
Outer Joins
Leftouter Join,
Rightouter join,
Full outer Join.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
how to perform back drill through in cognos 8 what is the use of it
Can you explain new content durability?
i was asked what are the caluclations done by you in your report? plz give reply
what is degenerate key in oracle ?whare do we use it?
What junk dimension contains?
Name the types of report?
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?
9. What was the most complex type of report you dealt with?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is dtm?
how you provide security to reports? How you provide security to packages ?
what is hints in cognos and where we use it.
Explain the different types of views used in cognos.
i have one file i saved in csv how can i take these file into framework manager