DSXchange

Yes I agree with DSGuru2B. In my project we have this kind of scenario. We always use 2 jobs and it works fine.
1. Dump the tables into dataset for reading (job 1)
2. Update the same table by lookup on the dataset (job 2)

Great...Good one Kim. Going thru this itself gives a kind of relief.

Extraction takes more time than load (25 min) and load is nearly 10 minutes.

Thanks.

Is there any other way I can improve the performance in parallel for this scenario?

Hi Gurus, I need some advice on performance tuning in datastage Parallel extender. This is the scenario. 1. I am using teradata enterprise stage to read a table and do some processing using lookup stage, sort stage and aggregator stage and finally loading 30 million records into the teradata table u...

Wish U all a Prosperous and Happy New Year 2007 with the new milestone of 15000 :D

Can u be more specific about the error ?

Ask the datastage admin to create
$APT_TERA_SYNC_DATABASE env variable. This will solve the issue

Hi All, The input is string ( the format is in within double quote "2006") and i need an output in integer( example: 2006). How can we do it in Datastage Designer? Please do help me to solve this.... Thanks and regards Subbu Use basic functions, (check in transformer) to strip the quotes ...

All, Thanks for your inputs. It worked. Just I put that syntax in shell script and it deleted. I also did a search in forum on querying the dataset. But I did not get any topics on that. I want to know any particular string is present on that dataset, uisng commands like orchadmin or any other comma...

Hi,

I just want to delete the datasets using unix shell script. Also want to view particular record in dataset thru unix.

This is possible thru orchestrate command (ORCHADMIN). If anyone have tried this, can please tell me the commands for these both.

Thanks

In the sequential file you have an option to reject incorrect records. Use that opiton and use DSsendmail provided by datastage to send mail