带有ETL的icCube连接表 [英] icCube join table with ETL

问题描述

我有一个Customers表，其中包含Employees表中的salesRepEmployeeNumber.

I have a Customers table which contains the salesRepEmployeeNumber which is in the Employees table.

我该怎么做

SELECT * 
FROM   Customers 
JOIN   Employees 
  ON   Customers.salesRepEmployeeNumber = Employees.employeeNumber

使用icCube ETL吗?

with icCube ETL ?

推荐答案

正如另一个答案中指出的那样，您可以基于将执行此操作的SQL语句添加表.如果您的原始数据源无法进行联接:

As pointed in another answer, you can add a table based in an SQL statement that would do the job. In case your original datasource is not able to do a join :

我们尚未进行联接转换，请将其添加到我们的待办事项列表中.同时，您可以做的是.

We've not yet an join transformation, added this in our todo list. On the meantime, what you can do is.

使用两个表创建一个联合表.这将使用两个表的列创建一个新表.首先放小部分，稍后我们将对其进行缓存.

Create an Union Table with your two tables. This will create a new table with the columns of both tables. Put the small one, first as we're going to cache it later on.

创建一个Javascript视图，您可能需要在icCube.xml配置中激活Javascript.在此表中，您可以缓存第一个表，并使用一些js进行联接.您可以在字段为空时触发表更改.不要忘记将表格行排序"保持表格顺序.

Create a Javascript view, you might need to activate Javascript in your icCube.xml configuration. In this one you can cache the first table and use a bit of js to do the join. You can trigger the table change on a field being empty. Don't forget to put 'Table Row Ordering' to Keep Table Order.

希望有帮助

这篇关于带有ETL的icCube连接表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！