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
- 13367 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
What are pre and post-session shell commands?
differences between service based and product based?
How can we improve session performance in aggregator transformation?
Explain in detail about scd type 1 through mapping.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
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?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the types of lookup transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is mapplet in informatica?
Whats there in global repository
What is primary and backup node?
EXL informatica Questions
What will be the approach?
what is the complex transformation you used in informatica
