mhamedbenjmaa opened a new issue, #7077: URL: https://github.com/apache/hop/issues/7077
### What would you like to happen? Hello all If any of you is old enough and had the chance to use Cognos Datamanager before these idiots from IBM shut it down he will remember that that ETL was designed around kimball philosophy , its was sooooo good we produced datamart and olap cube at industrial quantity and phenomenal speed without compromising quality and reliability , because it think only with fact and dim table and pretty much do all the work for you As you know today Data vault 2.0 is taking a nice place in modeling field and for a reason, its awesome fast and really reliable and is a good fondation for a staging and historical layer So, after this long introduction, what about we create a fast forward data vault creation tool, can be a wizard, a json spec given as input to a component or whatever way to input the request , I give him a table as input, i give what is business key, what are the satellite columns the requested hash type, the date column name if it want to use lookup for insert only new line or rely on destination error handling and BAM it will generate a hub table and sat table pipe in a sec ! as second step we can industrialise the same way the link table, so we give whats the sat 1 whats the hub 2 whats the business key that link both the requested hash type, the date column name if it want to use lookup for insert new line or rely on destination error handling and bam we generate the link table in light speed So im a developer , i have 50 tables, I can create a raw vault 2.0 in 30 minutes with that , i just did 50% of my project the business layer I can focus on now but all repetitive fastidious hub, sat and link creations are fast forward and already behind me so ? what do you thnink ? ### Issue Priority Priority: 3 ### Issue Component Component: Other -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
