What is Factless fact table ???
- 12 Answers
- 41356 Views
- Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / rajkumar bachu
A Fact table without measures(numeric data) for a column is
called Factless Fact table.
eg: Promotion Fact(only key value available in FT)
| Is This Answer Correct ? | 46 Yes | 4 No |
Post New Answer View All Answers
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Can we create multiple integration service on single repository?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
update strategy transformation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the difference between source qualifier transformations source filter to filter transformation?
What is the commit type if you have a transaction control transformation in the mapping?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
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.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain load alternative records / rows into multiple targets - informatica
How do you promote a non-reusable transformation to reusable transformation?
What is fact table? Explain the different kinds of facts.
what is the complex transformation you used in informatica
Which development components of informatica have the highest usage?
