DSXchange

us1aslam1us

Sorry, I mean a SQL job script created for publishing reports.

us1aslam1us

Hi Dxians, Can someone suggest me how to run a SQL server job GUID after the Successfull completion of the DataStage Job. I think i can use the Execute command stage to implement this but my confusion is: * Whether we can run SQL Server Job GUID? * What will be the optimized solution for this? Thank...

us1aslam1us

why don't you try the IsValid() routine Ray had suggested in his post.

us1aslam1us

Hi VCInDSX,

First, this is not the right place to ask your question? Now back to your question, you can access that video and some others if you click on the member benefits in the navigation section. Use the DSXchange Learning center link to access them.

sAM

us1aslam1us

Look into the Index() function.....

us1aslam1us

Just little change in Ken's Sql:

Code: Select all

Select * from Table
Where FiscalDate = (Select max(FiscalDate) from Table where FiscalDate < CurrentDate)

I think you can use the filter stage too for obtaining this.

us1aslam1us

check this link..

viewtopic.php?t=105949&highlight=COMO

sAM

us1aslam1us

Welcome Aboard,

Priya, A simple google search can guide you to the result.

sAM

us1aslam1us

what exactly are you trying to acieve? Have you checked the Rnd() function?

us1aslam1us

Is that your complete query or you have something attached to it? Also what is configuration file details?

us1aslam1us

Are they any warning/error messages in the log? Also have you checked your imported metadata, it sometime gives wierd results due to metadata mismatch. As Arnd suggested add two or three records to the current table and check.

us1aslam1us

Follow this link and see whether that can move you in a proper direction:

viewtopic.php?t=99149&postdays=0&postor ... ge&start=0

sAM

us1aslam1us

Here are some things you can check: 1. Check whether you are selecting the "Inner join" option correctly. 2. Any duplicates in the source or reference. 3. Any null values in the joining key. 4. Trim and sort the data before performing join on the key column. 5. Are you doing any partioning...

us1aslam1us

Thanks Ray, I guess that is happening here. Any suggestions that can help me in decreasing this response time. Will talk to DBA tomorrow for his word on this.

us1aslam1us

No Ray, I am not confused with that.

Will there be an issue in the response time when joining tables with the views?

DSXchange

Search found 816 matches

How to Run SQL Job GUID after DataStage Job