DSXchange

Thanks

Hi.
I am wondering what is the best way to calcuate the difference in seconds for two timestamps fields in Server job. Thanks in advance.

Thanks Craig

Thanks Craig. I am not planning to store the checksum on the table record. Does it make sense to calculate both checksum and compare? I am concerned more on the performance. I plan to just compare the concatenated value. What do you think?

I need to compare a table row with a row in a file to see if any field has changed. I am thinking to concatenation required fields and do the comparison. I am not sure if I should calculate the checksum then do the comparison. Which one is more efficient? Thank you in advance.

Thanks

Hello, One of the column of Oracle table changes from number(5,2) to number(10,2). Should I change the table definition accordingly in data stage? I have a feeling that data stage does not need to change. Since I do not have access to data stage currently, I can not test it out. Can some one tell me...

PhilHibbs, is there a specific reason you're passing to pxStrFirstCharList by reference and not by value?

I think I know what is happening here. This is caused by the "Enable partitioned read" on the data source. DISTINCT and "Enable partitioned read" should not be used at the same time.

Hi, Currently we are doing a left join (hash partition on Account ID) on two Oracle tables on Account ID. The left table is a simple select statement with more than 1 unique Account ID, whereas the right statement has the 'Distinct' keyword and only selecting Account ID's from the table. My question...

What links are you mapping the output of the SQL query to?

Thanks. 50 Bytes is the max length of the row

Hi Ray, it looks like ways more than double of the entire volume of the data set. It requries 4 or 5 times more than the entire dataset. I need to justify the space requested. Thanks

PaulVL wrote:What is the total length of your row? Not just the keys.

The total length of the row is 50 bytes

I have to sort data with volume of 900 million records. The sort is on two keys with 26 bytes in total. The sort is not stable sort. If I caluclate 900 million multiple by 26, it should be about 23 G of data. But it consumes more than 200G of scratch disk space. What does the other data come from? D...