|
INTERVIEW QUESTIONS
DATA WAREHOUSING
BUSINESS OBJECTS
DETAILS
Question: clearly explain the difference between union and group
Answer: 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.
|
|
|
Category |
Business Objects Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8066 users |
Added on |
8/18/2011 |
Views |
69620 |
Rate it! |
|
|
Question:
clearly explain the difference between union and group
Answer:
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. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Are Data mart and DWH normalised or denormalised ? Do both of them exist in the same tier ?
|
View Answer
|
|
What is a Data Cube?What is its use ?
|
View Answer
|
|
is there any other repository domains rather than universe,security,doccument?
|
View Answer
|
|
what all will be exported to the repository, when we export a universe ?
|
View Answer
|
|
What is a bo repository
|
View Answer
|
|
Give the notes and functionalities of cascading prompts,@script in business objects
|
View Answer
|
|
When to use local filter and when to use global Filter?
|
View Answer
|
|
What are the user requirements in a universe?
|
View Answer
|
|
I have three predefined prompts.In a report it will come randomly.How they will come in a specified format?
|
View Answer
|
|
What’s universal join in BOs?
|
View Answer
|
|
Can we apply Rank and Sort at a time on a single report
|
View Answer
|
|
What is difference between custom hierarchy and report based heirarchy?
|
View Answer
|
|
What is the multi value error ? Is there any types of Error in BO
|
View Answer
|
|
How many ways we test the universe & Report?
|
View Answer
|
|
How achieve the many to many relation ship in Business Objects...
|
View Answer
|
|
How to filter repeatative values in the report to get distinct values.
Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann't manipulate source system.
Is there any command or function to filter repeating records/values in the report.
|
View Answer
|
|
What is the diferrence beteeen tabular report& cross tab report
|
View Answer
|
|
Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)
|
View Answer
|
|
My query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?
|
View Answer
|
|
What is the difference between condition & filter.
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Business Objects Interview Questions & Answers - Exam Mode /
Learning Mode
|