DSXchange

Thanks Ray & jwiles ,

the job parameter given by Ray is working fine for me .Thanks for your help ...

It has to be chosen arbitrarily at runtime....

S i did read the Parallel Job Developer Guide ..

Thanks for your suggestion jwiles.

any one can help me out with RND() funtion in transformer ? Please to get the Random data..

Ray,

Thanks Ray ,But If we use HEAD stage it will give the every Nth records ... if we give period..,but as per my requirment i shuld get randomly not every Nth record.

Actually my requirment needs equal amount of Random Data from each state ( Eg: 100 Records from each state (Key column) if there are 50 records in one state it shuld pick all 50 records ) .If i go with Sample stage if i give the percentage it will give the percentage of all the records ..means it mi...

Thanks Ray ,

I appreciate your help ,Can u please elaborate how can i seed in the Rnd() function and how can i use it .Please ..

Our Source is DB2 ..

Hi All,

I have a secenario where i have to select Random rows (i.e., equal amount of random rows from key column (STATE) randomly ) .I'm trying to use RANDOM function in transformer .Please help me how can i select random amount of rows ...