Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14742 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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to load last n records of file into target table - informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Performance tuning in UNIX for informatica mappings?
What is sq transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Is it possible to define a single node as a Gateway node as well as worker node?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is domain in terms of informatica?
How to create a non-reusable instance of reusable transformations?
How does the aggregator transformation handle null values?
EXL informatica Questions
What is event and what are the tasks related to it?
