Explain factlessfact table with scenario
Answer / tamilarasan
Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done
| Is This Answer Correct ? | 0 Yes | 0 No |
HOW DO YOU CONNECT TO REMOTE SERVER ?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
in which situations do u go for scds ?
"Change cache" in Informatica ?
Difference between Target-based loading and constraint-based loading?
Explain incremental aggregation in informatica
What is a snowflake schema?
Explain the pipeline partition with real time example?
what is song in infrmatica...?
Differentiate between source qualifier and filter transformation?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
how to sort date field in infomatica?