Data shuffling in Datastage

krishna14 · Post by **krishna14** » Thu Apr 14, 2011 8:32 pm

Hey,

I have a situation where i have to shuffle the data for every run ..

and my source id DB2.. target is flat file ..

Please help me out on shuffling the input data in datastage..

ray.wurlod · Post by **ray.wurlod** » Thu Apr 14, 2011 8:48 pm

Generate the SQL query externally and pass it to the DB2 Connector as a job parameter.

krishna14 · Post by **krishna14** » Thu Apr 14, 2011 9:22 pm

can you please elborate & explain the SQL query...Please.

chulett · Post by **chulett** » Thu Apr 14, 2011 9:39 pm

Perhaps you can illustrate for us what exactly it is you mean by "shuffling the data" in this context rather than making us guess.

krishna14 · Post by **krishna14** » Thu Apr 14, 2011 9:46 pm

Actually my requirement needs different random records for every run of same input DB2 file ,if i can shuffle the data coming from db2 .i would be able to get the random records out of it for every run for the same inout DB2 file..this is my scenario i have to work on ..

chulett · Post by **chulett** » Thu Apr 14, 2011 9:50 pm

How is this any different from your ongoing "Help regarding RANDOM data selecting" post?

krishna14 · Post by **krishna14** » Thu Apr 14, 2011 10:00 pm

No it is not different ..

actually i got the Random selction of data job done ,but for every run of the job i am able to get the same output random values ....
my criteria needs to get the different Random values for the same input DB2 file.....

chulett · Post by **chulett** » Thu Apr 14, 2011 10:16 pm

That's what I thought, so we'll just lock this one and you can continue the discussion over there.