Page 1 of 1
Data shuffling in Datastage
Posted: Thu Apr 14, 2011 8:32 pm
by krishna14
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..
Posted: Thu Apr 14, 2011 8:48 pm
by ray.wurlod
Generate the SQL query externally and pass it to the DB2 Connector as a job parameter.
Posted: Thu Apr 14, 2011 9:22 pm
by krishna14
can you please elborate & explain the SQL query...Please.
Posted: Thu Apr 14, 2011 9:39 pm
by chulett
Perhaps you can illustrate for us what exactly it is you mean by "shuffling the data" in this context rather than making us guess.
Posted: Thu Apr 14, 2011 9:46 pm
by krishna14
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 ..
Posted: Thu Apr 14, 2011 9:50 pm
by chulett
How is this any different from your ongoing "Help regarding RANDOM data selecting" post?
Posted: Thu Apr 14, 2011 10:00 pm
by krishna14
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.....
Posted: Thu Apr 14, 2011 10:16 pm
by chulett
That's what I thought, so we'll just lock this one and you can continue the discussion over there.