This Informatica project involves Extracting, Transforming, and Loading (ETL) data from two CSV files: Churn_Modelling2.csv and Churn_Modelling3.csv. The objective is to perform various analyses on the data and generate specific outputs as outlined below.
- Calculate the sum of balances for male and female customers.
- Determine the number of active male and female customers.
- Group customers based on age distribution into the following categories:
- Age between 18 and 30
- Age between 30 and 45
- Age above 45
- Identify users with available balance data (balance > 0) and rank them in ascending order.
- Retrieve all information for customers with the top 5 balances.
- Find the highest and lowest credit score values.
SumBalance_M_F.txt: Sum of balances for male and female customers.Count_Active.txt: Number of active male and female customers.Age distribution tables.Balance_Sorter.txt: Users with available balance data.Rank_Balance.txt: Information for customers with the top 5 balances.max_min_score.txt: Highest and lowest credit score values.
- Ensure Informatica PowerCenter is installed and configured.
- Import the CSV files
Churn_Modelling2.csvandChurn_Modelling3.csvinto Informatica PowerCenter. - Create mappings, transformations, and workflows to perform the specified tasks.
- Execute the workflows to generate the output files mentioned above.
- Ensure the input CSV files are correctly mapped within Informatica PowerCenter.
- Validate the transformations and mappings to ensure accurate data processing.
- Monitor the workflow execution for any errors or issues.
- Adjust any parameters or configurations as needed to optimize performance and accuracy.