Answer Posted / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How identifying bottlenecks in various components of informatica and resolving them?
my source is junk data how will u remove that junk data by using unix please any one replay me
Describe expression transformation?
What do you mean by enterprise data warehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Clarify the utilization of aggregator cache record?
What is a dimensional model?
What are the restrictions of union transformation?
What are the components of workflow manager?
Explain what is informatica metadata and where is it stored?
What is the meaning of up gradation of repository?
can u give example for factless fact table
What are the different types of repositories created using informatica?
What is the status code in stored procedure transformation?