Few doubts

[sairaochowdary]

Hi anyone
I have few doubts in following areas.Any one could help me in this regard
1.what is meant by materialized view
2.can we import oracle packages into catalog.
3.what is meant by confirmed fact
4.do we have option of creating optional prompts in impromptu.

Thanks
Sairaochowdary

 

[Exie]

Hi Sairaochowdary,

I'll answer what I can.

1. Once described as: A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.

You can get the full story Here

2. No. (well, not that I've ever heard of!)
3. Need more information here ... where is the term "confirmed fact" used ?
4. No.

 

[Nunina]

I agree with Exie.

1. He already answered.

2. We cannot import oracle packages into a catalog.

3. ?????

4. No, but you can create them in a catalog. First create a calculation or filter and use that as the base for the prompt.

Good Luck!



Issys Pouerie
Systems Support Analyst
San Juan, Puerto Rico