Answer Posted / itesh

Yes it’s possible,

Since after all its a table, if you have the proper
relationship no problem,

Conceptually it’s correct to have a have confirmed
dimension but it can be manipulated,

Ex.

I have one fact a table FACT EOD this year i have joined
with EOD FACT Last year with time id .its working fine

Again
If you have two fact table A and B then create a derived
table from B Of the required key and measure only and join
with original fact table A ,

Better check with a sql query.


Nothing is impossible……

Cheers
I

Explain what is the difference between stop and abort?

1041

---

Explain what is the advantages data mining over traditional approaches?

1027

---

What are session timeout and application timeout?

1016

---

Explain can report net connect multiple datasource at a time in report creation time?

921

---

How can you import tables from a database?

1081

---

what are the all possible features supported modify stage?

2135

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

910

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1088

---

Code the tables statement to produce a multi-level frequency?

1009

---

Explain what are non-additive facts in detail?

1034

---

What is the difference between ods and oltp?

1012

---

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1001

---

What is your spectra photometer working principles?

980

---

Explain what is the difference between power center & power mart?

999

---

How to calculate fact table granularity?

1016

---