DSXchange

Actually there was no primary key defined on the table. So there were some duplicates which caused this error. Now the table has been assigned a PK. now it is fine

I am using a server job in the following format Seq File---------->Transformer-------------->ODBC Stage Data is being loaded from seq file to a DB2 table. I am using the option "Update existing or insert new rows" in ODBC stage The metadata format is exactly same for seq file and table. Th...

I understand from Ray's post that PX is designed in such a way. This clears my doubt. I thought there was some problem with my job. Thank you

If you use a Lookup File Set stage you won't get View Data either. Some stages just don't support it. Any stage that invokes a bulk loader does not support View Data when in bulk loader mode. End o ... So if at all I want to view data in the target, what options should I specify in the properties?

us1aslam1us wrote:I suggest you to read Ray's post again. In both Bulk load stage and Enterprise stage, the bulk loader will get invoked and you won't be able to 'View Data' unless you are using API stage.

Sam

If I use the API stage, I wont get parallel functionality. So I cant use that.

Is the 'View Data' button visible or grayed out? If it is visible, then what is the error message that you see when you click on 'View Data'? FYI: If everything is defined right, then you should be able to view data even if the DB2/UDB stage is used as the target stage. Period. Whale. The View Data...

I am using the DB2/UDB stage from the pallete. But the same, I have used in source as well as target. I am able to view data in source. Not in target. Please explain

Tried changing the write mode also. Still no effect

I tried the following

Write Method: Upsert
No effect.

Write Method: Write.
No Effect.

What about the Write Mode? Should that be changed as well?

I am using a PX job which is populating a DB2 table from source DB2 table. Target is an exact copy of the source except that the target table name is different (thats obvious :)). The structure of the job is like this: Source DB2 Stage------------>Transformer------------->Target DB2 Stage Target Pro...

This post is related to DSXchange website. I am not able to mark a topic resolved. When I try to do so, I get a failure dialog box.

Not sure if this is limited to a single forum or multiple ones. But going by the posts above, I think many are facing this issue. Wonder whether the Webmaster is taking note of this?

1) I specified hash partition in the input of Sort Stage. There is check box item "Perform Sort" with two sub properties "Stable" and "Unique".
What are those?

2)What should I specify in Join Stage Partition tab. Currently it is Auto

What if the output from DB2 is grouped but not sorted? What should be the partition method to bbe used in the Sort stage? Currently it is Auto.

I had the same problem a week ago. (I thought I was a one time thing, but this confirms that I was not the only one who got it) I tried it the next day and I was able to mark it is resolved. Don't know what happened. Try doing it after a while, log off/log on or may be next day. This is just a work...