Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
Answer Posted / preeti
Factless Fact is having only dimensionla keys with no
measures.Its basically only to get information and no
calculations involved.
For eg:how many no. of Policy closed last month
we might say Factless Fact Table basically used to support
negative analysis report
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by a domain?
tell me about your project functionality
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is blocking transformation?
How can we remove the duplicates from flat file source?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are active transformations.
Explain how many types of dimensions are available in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
Why update strategy and union transformations are active?
What are the various types of transformation?
How do you load unique records into one target table and duplicate records into a different target table?
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 is informatica powercenter repository?