Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
- 6 Answers
- 13063 Views
- I also Faced
- E-Mail Answers
Answer Posted / purnima
to combine two diffeerent diminsions information we use
fact less fact table.
for ex:if we want to get deatails about a promotion
information like when it is lauched.we will get that
information from promotion dimensions and time
dimension ,so in this scenerio there is no need of any fact
information but we need data from thes two dimension then
we go for factless fact table
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Why sorter is an active transformation?
What is the way to execute pl/sql script using informatica mapping?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Differences between version 7.x and 8.x.
Describe expression transformation?
How you can differentiate between connected lookup and unconnected lookup?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Mention few advantages of router transformation over filter transformation.
What is option by which we can run all the sessions in a batch simultaneously?
can we override a native sql query within informatica? How do we do it?
Mention few power centre client applications with their basic purpose?
What if the source is a flat-file?
What could be the possible resons of locks by user?
What are the new features of informatica 9.x developer?
