Hi all,
Can you please send me the Dimensions and fact tables
which are used in mutual fund project. and please send me
the brief summary about the project.
Please do the needful.
- 1 Answers
- 2389 Views
- I also Faced
- E-Mail Answers
Answer / Virendra Kumar Kashyap
In the mutual fund project, the following Dimensions and Fact tables are typically used:nn - Fact Table: Mutual Fund Transactions (MFT)n - Description: Contains all financial transactions related to mutual funds.n - Key Columns: Transaction ID, Date, Fund ID, Quantity, Price.nn - Dimension Table: Mutual Funds (MF)n - Description: Contains information about the mutual funds.n - Key Column: Fund ID.nn - Dimension Table: Time Period (TP)n - Description: Contains time periods for financial analysis.n - Key Column: Date.nn The project aims to create a data warehouse to store and analyze mutual fund transaction data. It involves ETL processes, data modeling, and report generation.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
What is workflow manager?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Define update strategy?
Describe expression transformation?
How to call shell scripts from informatica?
how to duplicates from expression transformation without using sorter before that
what is $$$$?
Teradata 
