DSXchange

Hi all,


I have to pick up data from a column randomly.My column datatype is varchar.I am using datastage 8.1.How can I do this????

We'll need a better explanation than that. Can you provide an example of your 'columns' and what the output of your 'random sampling' might look like?

Hi chulett

I have two input Sequential file each have two columns and their datatypes are varchar.My requirement is the output file have four columns.First two columns are direct mapping from first input file and other two columns have to be loaded with data randomly picked from the two columns in the second file.There is no business rule for picking up the data from the second input file.How can i do this.???

One potential method:

On your second file (which you will randomly select from), assign a sequential sequence number (NOT random) to each row. You could use row number generation in Sequential File stage, for example...this would probably be the best place to do it. The results should be 1, 2, 3, 4, ... number_of_rows

Knowing exactly how many rows are present in your second file, assign a random sequence number to each row of your first file, with a maximum value of the number of rows in the second file. You can use one of the random number functions in a transformer or use a column generator stage.

Then, using a lookup/join/merge, join the two files on the sequence number columns.

Regards,

Hi ashishm ,

is it resolved? If so let us know how you did it. Thank you

It's not marked as resolved, nor is there any indication that U (one of our posters) had any involvement at all.

The second person personal pronoun in English is spelled "you".

Thank you ray