SQL transform loosing SQL when getting latest version

dataservices job design
1

Hi,

I am moving my DS job with SQL Transform from local Schema to Central Repository. when I bring a latest version of copy to prod from central repository the SQL transform is missing sql.

does any one encountered this issue before. how do i resolve it?

also where does the sql query gets stored in meta data(table name)?

Thanks in advance!

dammalapatisree (BOB member since 2014-07-03)

2

I can’t recall seeing a similar problem for a long, long time with DS 3.2. What version of Data Services are you using?

ErikR :new_zealand: (BOB member since 2007-01-10)

3

Check to see which database version of the Datastore the SQL transform is using. For example, you could enter the SQL using version 11g of Oracle but if someone else’s Datastore is set to 8i then it will try to show the SQL for that version.

eganjp :us: (BOB member since 2007-09-12)