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
- 14526 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhanakkodi
I have two tables emp and dept
i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.
-- Dhanakkodi
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain your project of banking domian.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a difference between complete, stop and abort?
Can we create two repositories on same database instance in oracle?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
differences between service based and product based?
What does update strategy mean, and what are the different option of it?
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?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the scenario which compels informatica server to reject files?
expain about the tune parameters?
What are the types of schemas we have in data warehouse.
what is the size of your data warehousing?
