What is the procedure to load the fact table.Give in
detail?
- 1 Answers
- 8068 Views
- I also Faced
- E-Mail Answers
Answer / dr.journalist
Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.
| Is This Answer Correct ? | 2 Yes | 4 No |
What is the procedure for creating independent data marts from informatica 7.1?
What is the function of union transformation?
What are the different caches used in informatica?
Can you generate reports in Informatcia?
What is a sorter transformation?
What is an aggregator transformation? it is active why cant it be passive explain?
What is a configuration management?
checkout and checkin in informatica 8.6
how many types transformations supported by sortedinput?
Explain joiner transformation in informatica
how to create user defined function (udf) in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Teradata 
