What is Factless fact table ???
Answer Posted / tadikonda
FACT TABLE CONTAINS ONLY ID,KEYS AND DESCRIPTION COLUMNS AND
NOT MEASURES ARE KNOWN AS FACTLEES FACT TABLES
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
What is data transformation manager process?
Explain pmcmd command usage in informatica
What are batches?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to load a Dimension ? and how to load a fact table?
What is a transaction control transformation?
How to generate sequence numbers without using the sequence generator transformation?
Enlist the tasks for which source qualifier transformation is used.
What are the different types of transformation available 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
Why update strategy and union transformations are active? Explain with examples.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is resilience time?