0

Copy Data Stage Logic for Multiple Data Sources

Malcolm Johnson

November 06, 2018 10:14

None

Follow

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

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis November 09, 2018 16:08

  Hello Malcolm -

  This is no automated method for copying the Lookups and Data Transformations from your initial NAV data source to the new NAV data source in the Stage.  That work would have to be done manually.

• 0
  
  Johannes Herlitzius November 12, 2018 11:44

  Hello Malcolm,

  I'm not entirely sure, if I understood your setup or request correctly. Anyway, I have three data source based on NAV, which are somewhat similar. For the tables and fields that are consistently available and used in all three sources I use replicate data sources:

  https://support.jetglobal.com/hc/en-us/articles/218952618-How-to-Replicate-Data-Sources

  You have to choose a data source. Then you can add additional data sources that are loaded together with your first data source into the same table structure. This is especially useful, if most tables and fields are the same in all data sources. If not, you can either choose to not load a field or table or to add it manually via another data source to your staging area (depending on your license agreement).

  If you are more interested in this approach and you still have some questions, please tell me. I can try to explain it more carefully then.

  Let me know, if this helps.
  Best Regards,
  Johannes