Interested to Buy Any Domain ? << Click Here >> for more details...
What is the procedure to load the fact table.Give in
detail?
- 1 Answers
- 8830 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are connected or unconnected transformations?
Why do we need informatica?
What is a difference between complete, stop and abort?
What is the session task and command task?
What differs when we choose the sorted input for aggregator transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What is flashback table ? Advance thanks
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
COM components can be used in Informatica
In how many ways we can create ports?
What is workflow? What are the components of workflow manager?
What is main use of mapplet?
What is the use of code page?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
