DSXchange

Still not working. It continues to say DB2_Delete_Update,0: Statement DELETE FROM <tablename> WHERE KEY_1=? failed to run. Am I missing something here? I peeked the output of the modify stage and everything is as expected except that KEY_1 is no longer present in the output. Instead TempKeyCol has t...

I see a lot of seemingly very useful solutions that have been tried and tested. But till I get my premium membership(which I've purchased and has not been activated yet ), I won't be able to see any of them.
Once I get around my membership issues with the admin, I'll report back

I have made a payment for 1 year to dsxchange but my profile has not been activated with Premium Membership. May I know when will it get activated? Is there a waiting period between the payment and the actual activation?

Hi All, I am trying to create a generic job that can, given the right table name and key column, delete the required records. Since the job uses RCP, i had to write a custom SQL since i could find no way of specifying the key column in a schema file. My delete query looks like this. DELETE FROM #SCH...

How is the key specified in a schema file? I came across this topic but the solution doesn't help.
I keep getting an error - Unrecognized type-specific format properties: {Key}

Is this really possible?

Hi, We have a RCP enabled job that performs all load activities. All other jobs have metadata defined within them. Once all transformations are accomplished, the data is sent to this RCP job for loading into the respective database tables. Can MWB establish the lineage between this RCP job and the p...

Once you import the mapping documents into FastTrack, they should be available in the metadata repository. I reckon you wouldn't have to take any additional steps for MWB to establish the lineage

Thanks RK72. That was the issue.

@ Ray : As because you are a premium member of this community, all that you post ends up into is a big GOLDEN BUTTON named "Premium Content" which takes me far away from the material content of your post :( :x .It would be greatly appreciating if you send in you reply to this post via a P...

Looks like the missing MSXML is the issue. http://www-01.ibm.com/support/docview.w ... wg27018060

Thanks for the suggestion, Ray. I'm going to try using the command line before trying to get MSXML. Thanks

The answer to your first question is elementary. You'd do better to figure out the answer yourself (Hint : Key Break or better still 'Looping' if you use 8.5 or above). If you can't, search the forum. It would be redundant if I repeat something as basic as that here. To answer your second question, ...

Introduce a stage variable in the transformer that will hold a sum. Initialize the value of this stage variable(svCounter) to 0. For a given group (combination of MEMBER & PHONE), increment svCounter by 1 when there's a record with KEY_CHANGE=1. When svCounter=2, then increment svCounter for any...

That's not the issue here. Col3 is the surrogate key column. The problem here looks two-fold.

1. The SK is generated with a different pattern than just a one-up.
2. The data looks all jumbled up

Do a hash partition using MEMBER & PHONE and perform a descending sort using the time-stamp column.In the sort stage, create the KEY CHANGE COLUMN. Your records should be grouped and sorted and will look something like this. M1 P1 T1 1 M1 P1 T1 0 M1 P1 T1 0 M1 P1 T7 1 M2 P2 T2 1 M2 P2 T2 0 M2 P2...

We are trying to connect to the cognos repository using the Import Export manager but every time we select the required bridge, the import export manager displays a blank screen like this. https://lh4.googleusercontent.com/-3W2GzuwwDo0/UI994TH3mGI/AAAAAAAAIRk/4XVLLYshMOE/s607/Untitled.png Any idea w...