DSXchange

Hi, We are facing thuis particular situation. When we call job from sequence, some of the paramter values are not passed to jobs. When we restart the ds Engine, it started working alright. But after some time, we are seeing the same problem. It is not happening always. It is sporadic in nature. Whic...

Hi Joe, I did not understand exactly what you want to achieve. Are you looking for duplicate records. You may identify record order (1st and 2nd), if you have primary key defined in the table and using surrogate key or sequence number (in increasing order). But order may not be that imporatant as yo...

Hi Divine,
Are the inputs are sorted and partitioned on the same keys?

- Pavan

Try this

SELECT distinct col1, col2, col3,col4
from tab1

Hi, I am looking for way to find the missing user defined environment variables in Production when promoting jobs from another instance. We are facing problems when developers add environment variables, and when admin promote jobs, they are unable to promote as environment variables are not availabl...

I have defined the key in CDC and all other columns from source are defined as excluded as value . Why did you define all values as "excluded values" when running 2nd time. Set Change mode as "Explicit Keys, All Values". This should work. "excluded value" will exclude ...

Hi, In one of my job I'm using CDC, I have to src links (hash partitioned and sorted ASC on my key). In CDC stage I'm using change mode as Explicit Keys, All Values I have run the initial run where my target has 0 records; all records got inserted. I got the change record in my source, there is a c...

Thanks for the reply

But i have waited for most than 4 hours for it to complete with no success

It actually died on my with a error which says

Compilation failed - no other information available

Hence my question on the limitation of the transformer


Thanks again

Arvind

We are working with px jobs

We are working mainly with px jobs.

This particular issue is when building a px job

We are working on parallel edition

Dear DataStager's *************** Problem definition *************** We have a third party tool change data capture tool called OMNI that identifies all changes to our SAP source data and generates .csv files for consumption into data warehouse Under a given situation, I need to compare all the chan...

You can use a transformer to increment the value. Use initial value, rownum if it is server job, combination of partition number, initial value and rownum to get unique number in parallel job.

- Pavan

Range Lookup is available in Datastage 8 (aka HAWK release)

If one want to achieve this by using one job only, they can use change capture stage. Where they can use before and after image of the record(s). with this, they can Identify inserts (new records), deletes (existing record in the target got deleted), updates or changes (changes made to record). We a...