Interested to Buy Any Domain ? << Click Here >> for more details...
What is Factless fact table ???
- 12 Answers
- 44731 Views
- Satyam, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhoshn
A fact table without any facts is called as factless fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rekha
A FACT TABLE WITHOUT FACT IS CALLED FACT LESS FACT TABLE
SUPPOSE WE NEED TO COMBINE TWO DATAMARTS ,ONE DATAMART
CONATINS FACT LESS FACT TABLE AND ANOTHER DATAMART WITH
THE FACT TABLE
FACT LESS FACT TABLES ARE USED TO CAPTURE DATE TRANSACTION
EVENTS
CHEERS,
REKHA
| Is This Answer Correct ? | 9 Yes | 16 No |
What is a passive transformation?
what is constraint based loading
What are ETL Tools?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
Explain the difference between mapping parameter and mapping variable?
To provide support for Mainframes source data,which files r used as a COBOL files
with out using update strategy transnsformation how to update the data in mapping level
How do you load alternate records into different tables through mapping flow?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Explain direct and indirect flat file loading (source file type) - informatica
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Teradata 
