how to link 3 fact tables
Answer / joel rodrigues
Fact tables are tables with lots of measure values and are
uniquly identified by a key, also a fact table can have a
foreign key. For Example custumer fact table is connected
to loan fact table via customer_id, and each record in loan
fact table is uniquely identified by a primary key on
cod_acct_no. Similarly customer table can be connected to
Savings fact table through customer id.
| Is This Answer Correct ? | 2 Yes | 1 No |
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
What are templates? Explain what you have created?
what are they different types of report in BO?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
Explain what are the steps to be taken to schedule the report?
what is fantrap ?
Explain when to use local filter and when to use global filter?
How to create an popup in the WEBI report if the report is showing partial result?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?