as a newbie in Bw i have a question.
I worked already with other etl tools (powercenter) where there are objects to join 2 tables and create a new one to create a total transforming process to load a fact table.
In BW an INFOSET is the only thing to join 2 odssen. On this a query can be created.
BUT HOW TO JOIN 2 TABLES (= only ODS object?) AND CREATE A NEW TABLE FOR FUTHER PROCESSING ????