DSXchange

hi,

Is there any Data Stage server certification available from IBM.

I got some information that there is no certification available for Data stage server before posting this question.

If it is available, can you provide price and duration information etc.

Can anyone help on this.

Thanks..

Thanks Guys... It is working fine

Hi All,

Is there any function available in data stage that is equivalent to "like" option in ORACLE.

Ex: select * from EMP where empname like '%MITH%';

Thanks

The last option may also be available in PX. when you use group by on any column then you may have to use last option.

If you are doing any group by, then other option could be use the MAX(Column) in the derivation column. this should solve your problem.

I have loaded the 5 GB file without any issues. It completed within 4 hours. When you click the view data it should come within seconds. Please check the options you have selected. It will work.

Hi, We have 100 files in our source folder. We want to move 10 files into 10 different folders. Moving 10 files can be done using Folder stage. But our concern is when first 10 files are moved to fisrt target folder, that first 10 files should be deleted from source directory. when i run second time...

Hi Ashwin,

Thanks for quick reply.

Could you please eloborate on this point.

hi Guys,


Can we call a environment variable in a routine. Will it be possible. Can anybody suggest on this.

Thanks in advance

Thanks folks for helping on this issue.

One thing I oberved that the performance of the sort stage is slow. Is there any way to improve the performance of sorter stage.

I have sorted the data before doing the aggregation. Here sorting is going through succesfully, but when it is doing group by on key columns in aggregator it is failing at 2 GB memory limit.

Can anybody help on this.

we do not have any Quality stage. we have to resolve this using server jobs.

could you please through some more light how to resove this issue.

we have also tried with hash file. but that also was taking lot of time than DB query. we are using only windows and server jobs to resolve this issue. No unix commands we are using

we can sort the data before doing aggregation. Would this work for 10 million records.

Any thoughts on this

Thanks for fast replying
we are using server jobs. could you please tell us how exactly we need to use stage variables to get this done.

Hi all, We are facing one problem in removing duplicates. we have 2 files. Each file has 10 million records. When we remove duplicates using Aggregator stage on 3 key columns, we are getting limitation on Aggregation memory. The job is getting aborted after the memory reaches to 2 GB, i.e after 15 l...