DSXchange

If you want checkpointed behaviour in part of your sequence and not in the rest, best thing to do is create two sequences, basically modularize your job. Thats one option. The other one is inside each job activity you will have option "Do not check point run". If you check that it will always run th...

Thats a wierd behaviour. You have processes running and apparently hung and they have no PID
I have read a few posts from Ray talking about version r2. These versions never went through complete QA. I advice to bring up this matter with IBM and request for a thoroughly tested version.

sveeramani wrote:This is not ETL task, for the long term maintenance

I say this is not an ETL task regardless.

kishoreramachandran wrote:no, the dates have got double quotes, thats the way it was created when i wrote it to a sequential file.

Dont create it with the quotes then. The quotes are the culprit. Or change your sql. Create the sequential file with quote character 000 to get rid of quote character.

Maybe less than 30 minutes. As told, it totally depends upon the record size.

kduke wrote:Awesome. Thanks for not passing me yet.

Your hilarious Kim. I can never pass you. You guys are my mentors. Post numbers are but a mere number, can never measure upto your senority, let alone passing it.

number of bytes per row multiplied by number of rows,
that will give you a good approximation

Still 2B Ray, still 2B. I am going for the stars
Kinda following your's and other guru's footsteps

Well you have the data with you. Try with the CDC, with the Join stage and at the database level. Do a bench mark. Present the results to your team and see which one better.

Na, i like the 2B with my name.
Thanks for your support and appreciation guys.

Do a unix level diff on the two files.

If time is of the essence then why are you exactly refraining from it. Have "they" asked you not to?

You have two options. Do it in DataStage via CDC or Join Stage. Or you can do it at the database level itself. Do a select * from table where key NOT IN your yesterdays table, to get changes.

What in the world............ Who is this person, We need Walter.... It's gone now. My reaction was along those same lines when I first encountered it. Ofcourse, Craig helped me to stay sane. That was nothing, I had more there and my wife saw what i was writing and she asked me to be polite. After ...

Search on the "prior component with same name" and you will know what it means.