Interested to Buy Any Domain ? << Click Here >> for more details...
What is the procedure to load the fact table.Give in
detail?
- 1 Answers
- 8763 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
How will the document be delivered to me?
What do think which one is the better joiner or look up?
Write the unconnected lookup syntax and how to return more than one column.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are pre and post-session shell commands?
What is the difference between router and filter?
How does a sorter cache works?
Which transformation should we use to normalise the COBOL and relational sources?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
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?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Name the different lookup cache(s)?
What is lookup transformation?
What is option by which we can run all the sessions in a batch simultaneously?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
