Q: What happens when I get collation issues when creating the repository?
A: Make sure the metadata repository is created using the same collation as the other databases you interact with. By default I always use Case Sensitive and Accent Sensitive collation.
Q: Why do I need two separate applications (TEAM and VEDW) to generate ETL?
A: We are working to achieve greater separation and interoperability between functions. To this extent we consider managing the metadata a separate function than ETL generation, and have split the tools accordingly. This means that, when the application mature further, it will be easier for everyone to use their own flavour of generation but still collaborate on the metadata management. At present there are various ways to generate ETL (Biml, VEDW, Handlebars and plain SQL) that all use the TEAM interface.