Interested to Buy Any Domain ? << Click Here >> for more details...
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
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?
What is the scenario which compels informatica server to reject files?
Explain lookup transformation source types in informatica
waht type of interface is used for testing the data in informatica
What is a connected transformation?
In how many ways we can create ports?
Explain lookup transformation is active in informatica
how to load rows into fact table in data warehouse
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is dimensional table?
What does role playing dimension mean?
What is the cumulative sum and moving sum?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is confirmed fact in dataware housing?
