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 |
What is the difference between STOP and ABORT options in Workflow Monitor?
performance tuning of Informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
How do you take care of security using a repository manager
what is the difference between onsite & client site?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
What are the active and passive transforamtions?
What is a stored procedure transformation?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?