0

Copy Data Stage Logic for Multiple Data Sources

Hi Guys

I have an Analytics project with multiple NAV data sources, and I am looking for a quick way of copying the work in the Data Stage from the initial setup found in the project downloaded from the Cube Store into the second instance.  to explain:

When you download a project and connect to the first data source Jet sets a large number of additional Lookup and other calculated fields in the Data Stage tables.

When connecting to a second or subsequent data source I used the Selection Template to copy the basic selection from the first connection to the second instance.  This creates a parallel set of tables in the Data Stage, However these tables don't contain any of the Lookups etc. that Jet creates in the initial load. 

Is there a quick process for copying this Data Stage logic into the subsequent load?

Thanks

Malcolm

2 comments

Please sign in to leave a comment.