DSXchange

I know. Old habits die hard Craig, and i like spider webs, me a huge fan of spider man
Kris, I stand corrected. But still, i would like to try that out.

Go to the Job Properties Tab and select the option Automatically Handle activities that fail and you are all set. This is based on the assumption that you have not defined any failure triggers for any of your Job activities. That will handle the jobs and not abort it. Even if you dont do anything a...

Totally lost you. YOu are looking for a script that does what to the job control.

I agree. Saving it from the job is actually the quickest way. Otherwise, as Arnd mentioned, you need to create a VOC entry for each and everyone of them to be able to inport it as Universe file definition.

O, i get it now after re-reading Ray's post. Mybad Craig.

Me too. What is going on. Craig, are you pulling Kumar's leg

Also, you need to always keep in mind, what time, or what part of day or night is your process going to run when it goes live. If during that time, not much database activity is taking place, then i would suggest doing aggregations sorting and joins at the database level.Transformations can be done ...

Its more like, dont go to the extent of Hacking if, unless, absolutely required. I know hacking is fun, but fun can turn out to running around finding ways to fix a corrupted project. And ops, no backup. Wow, thats a big ops. Also, i believe in the HAWK version, the client will have the choice of an...

When you are inserting the dates, what format code are you using? Doing a google on the error code reveals that others got this error when invalid date code was used.

Try to go through my logic. In that, it doesnt matter how many times abc or for that matter any other value exist. All you need is to be sorted by val1 and the design will take care of the rest.

Yes, I agree with you Ray. Most of the time people just sign up twice I guess. But having 12000+ users for DS in reality doesnt seem to me a right figure. I would decrease that year limit to 2 years, as to my knowledge may be I am wrong, Datastage has gained popularity in the past 2 years itself.

Welcome aboard Sort your incoming data by val1. Use two stage variables to do the group changing dance, say cond and prevVal. They should be in the same order as i specified. cond first and prevVal second. cond- if @INROWNUM =1 OR INLINK.val1 = prevVal then cond:INLINK.code1:INLINK.val1 else INLINK....

In addition, you need to get in touch with your data modeller. Identify the parent table and the child tables. What level are they in, what relationship exists between the tables. For an ODS (hierarchical model), start from the code tables, then the parent tables and work your way below. For a wareh...

IMHO
The inactive users that are not charter members need to be re-considered by the Admin on how to go about with unending list.

This might help in increasing the site performance.

PS: Only 3303 Posters have posted atleast 1 post.

Thats fine. But the link collector will go for roundrobin processing. It will take the first record from 1, first record from 2 and then first record from 3, then come back to 2 and continue. SO your output file will look like header detail trailer detail detail ....... ....... ....... ....... Thats...