DSXchange

In the transformer, are you using IsNull function for that column ?

Whats the error ?

Use 3 stage variables in the transformer, sort and partition the data on the MEMBER_ID. I dont have access to datastage right now, but the above logic should work.

@qutesanju
Those "squares" are because of char datatype and are actually blanks which are padded to the fixed length if the data has a shorter value.
The only solution to this problem is changing the data type to varchar.

All of my posts and points will be kaput..

Perhaps this post might help.

As told by Ray, either use $APT_DATE_CENTURY_BREAK_YEAR variable in your job parameters or using the below code in transformer while doing conversion
StringToDate(<date>, "%2000yy-%mm-%dd")

As asked above you need to find the "Day 0" value. Mostly it is generic but sometimes project specific like in my project its 1899-12-31. So once you find it you can use any of the below functions :- date('1899-12-31') + n days If you are having a database as your source. DateFromDaysSince...

vamsi, I dont think that you'll be able to to do that.
If your query has multiple tables in it, then its difficult to achieve partitioned read.
But you can test it at your end by running the job and taking the driving table of your query for partitioned reads and match the count. Give it a try.

Aye Aye Captain..

Did u enable the microseconds at the metadata level in the transformer ?

I think It will not affect the aggregator performance, as I have used the same in DB2. And for your 2nd point, hope this might help.

<corrected>

I think enabling Hash partitioning in the source would help.
And what about the partitioning at the target level ?
Also how much data we are talking about here ?

First things first, did you try to search your issue ?
There are atleast hundreds of posts with exactly same issue.
Even then, try this Also enable the microseconds at the metadata level in the transformer.

Hi Moderators,
Is it possible to change the username ?
As you see, mine contains the email id of one of my TL who introduced us to this website. Now he's gone and still we use the same username. Is It possible to change the username to something generic ?