Interested to Buy Any Domain ? << Click Here >> for more details...
Do you know about Initialization Blocks? Can you give me an example where you used them?
- 1 Answers
- 2611 Views
- I also Faced
- E-Mail Answers
Answer / madhu
Initialization blocks are used for instantiating the value of a variable.
To create dynamic variable you have to create IB to write SQL statement. The result of the query would be assigned as value to the variable.
| Is This Answer Correct ? | 3 Yes | 0 No |
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
How will you create report from two subject areas
How we are going to decide which schema we are going to implement in the data warehouse?
What are the things you can do in the BMM layer?
How to sort columns in rpd and web?
What is scd type 1 and 2.
How will you do sort in reports in obiee.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What is level based metrics.how will you create it?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
Can you use outer join in BMM layer?
What is a bridge table ?
Teradata 
