Author Topic: New Fact build to run based on table existence  (Read 3168 times)

Offline avi25ge

  • Associate
  • **
  • Join Date: Feb 2008
  • Posts: 3
  • Forum Citizenship: +0/-0
New Fact build to run based on table existence
« on: 04 Dec 2016 12:28:06 pm »
Hi,

I am building a fact build to hold historical rejects, on top of an existing Data Manager reject table, which gets dropped and created each time the load runs. What is the best way to do this? Also, what is the way to check for a table existence and then run the Fact build? Add a SQL node for checking existence of the reject table and then run the build?

Thanks,

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,864
  • Forum Citizenship: +647/-10
  • Cognos Software Muppet
Re: New Fact build to run based on table existence
« Reply #1 on: 05 Dec 2016 04:02:55 am »
Hi,

I am building a fact build to hold historical rejects, on top of an existing Data Manager reject table, which gets dropped and created each time the load runs. What is the best way to do this? Also, what is the way to check for a table existence and then run the Fact build? Add a SQL node for checking existence of the reject table and then run the build?

Thanks,

Hi,

Is the problem just detecting the existence of the table, or do you need some way of knowing when the build populating that table is complete? If the former, you could use a SQL node in a jobstream to test for the existence of the table. If the latter, you'd probably need to have your build set a flag and look for this to exist.

Cheers!

MF.
Meep!

 


       
Twittear