DSXchange

I am using DS 8.5 and recent times when ever I open the XML Stage Assembly editor it shuts down with the following info: " CDIUI4615E The session with server '{0}' has expired. Please restart the {1} application. Server status code is 408. Existing jobs already using this stage runs fine. Any h...

Hi I have some queries regarding the new feature in Datastage 8.5 where Connectors support multiple input links I am not able to find a detailed spec about this new feature. But would like to know what is the advantage over using multiple connectors? How does it help in perfomance? What is limitatio...

thanks much for all your comments. this is more information and i would continue refering to this page to build the CoE Capabilities.

It would be really hard to cut out a concrete reason. but yeah we can come up with the guidelines.

Hashing alone wont do. Sort them on the joining Keys,

FUNCTION myGetRowCount(JobName,StageName,LinkName)
$INCLUDE DSINCLUDE JOBCONTROL.H


hJob = DSAttachJob(JobName, DSJ.ERRFATAL)

RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)

ErrCode = DSDetachJob(hJob)

Ans = RowCount

You can build a simple Transform Routine to see how many records have gone through a particular link. Get this count into the sequence

Hi, Though there are forums which compare scheduler vs sequence job, I wish to revisit the question again to understand more on this. We are currently building a Center of Excellence Model in our organization and the decision point will impact a huge no. of audience. There are recommendations to sch...

Can you please guide me in this following scenario? I have an input source with the following attributes in my input. Key,NumericType1,NumericValue1,NumericType2,NumericValue2,NumericType3,NumericValue3,CharType1,CharType2,CharType1,CharType2 I need to pivot Numetic TYpe and CharType as below Key,Nu...