Forum Discussion
Creating Dimensions from a flat file
I have an aggregated flat file taken from a view on our sql database and i want to turn this into a star schema. I work for an anti fraud software company. Each row represents an aggregated v...
Can you provide some sample data so that can provide more suggestion for you,what the relationship among the fields such as one to many or many to many?
Best Regards!
Yolo Zhu
- Hi, do you need any additional info above the above data provided?
What the output you want to achieve? can you provide some sample output?
Best Regards!
Yolo Zhu
I'd just like to know if I should bother creating a star schema from this flat file. So the expected output would be a star schema. I know the recommendation is to star schema but I currently have this very wide flat file - i want to know how I would go about creating 5the star schema from this data i have shared if poss
