DSXchange

There is no problem with membership activation whats so ever... mine done in hour...
Thanks Ray, Happy holidays!

Aditya,

Any update on this yet? I just purchased premium membership, I am member since 2005 .

If you think loading (not extraction) is the problem, try to tune the table in the database increase commit level or something like that ..13lac recs are no biggy for DS should not take the time you specified.

I think Table look up is kiiling your time...
If data sets are small enough handle with hash files...
Then you'll see it stops sometime

An XML job report will give you the file name with Directory name of the source or target file stages....try to read this report for filename...

NO CHEATING

Hardcode the filename as the stage name, then get the stage name with DSGetStageInfo.......

Just millions of grnads........

I think unconditional part makes sense to me (yeah It is common) but try to do some research on the reset if required part

You can always save jobname_suffix(corresponding to that category) and save it

Using DsGetLinkInfo function get the count of rows writting in to the link which is connecting to that table, say Variable 'NumOfRows' If NumOfRows > 50 Then UtilityAbortToLog("Number of rows exceeded the 50 aborting the job...") Else Null So that you don't get any issues still you can see...

I think it is better if there are no warnnings,
But as of now...
Unschedule the job.. go director - tools - options- limits-check no limit warnings.
Then rescedule it.
If you done this way ignore this response.

If you save (before compilation) a job design through your designer, DS engine creates all th run time files like RT_LOGnnn,RT_CONFIGnnn...
If RT_LOGnnn file is not created or deleted you can't compile that Job.

Replace DCOUNT with COUNT
Hope this solves your prob

Thank you very much Manteena , i tried your method , but instead of sequential stage , i used IPC stage , that worked. But i just need a clarification , on using LC , like on how would i know whether i need to use sequential stage or IPC stage before or after link collector, any guidance , greatly ...

load the each TX output to the seq files and them connect the file outputs to the LC then to the target file.
If u don't want the intermediate files, you can always delete them from after the job subroutine