adspace


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / Virendra Kumar Kashyap

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1226

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8304

What is dimensional table?

1180

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1258

Explain in detail about scd type 1 through mapping.

1659

draw informatica architecture 8.6 ?

3959

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2429

How do you remove duplicate records in informatica? And how many ways are there to do it?

1247

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1214

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2842

Explain scd type 3 through mapping.

1091

EXL informatica Questions

1469

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1685

What is dimensional table? Explain the different dimensions.

1279

Write the unconnected lookup syntax and how to return more than one column.

1184