What is the stored procedure ? What is the need of stored
procedure ? How to create a stored procedure Universe?
- 1 Answers
- 5214 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
Store procedure is used to excutea set of sql queries ,
Its used in the scenario where the query is used in
mulitple times.
there is a option in the designer to retrive the structure
of the universe through store procedure.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the dense rank?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain how to schedule the report in b.o?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain the difference between union and group?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain how many universes can be created in a project?
What is top business?
What are the join problems comes appart from loop,chasm & fan Traps
Explain in detail about type 2(scd),
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between user and versatile user?
how to create metric universe ?
Explain about alerts in bos, under what situation we need to use alerts?
