DSXchange

iam loading a table to an oracle database from a source oracle database using oracle stage. Iam creating/replacing an existing table in the target. Iam able to load the table but the problem is it is loading the last half of the rows(from source) at the start of the table (in target). what could be ...

iam not a premium member. can you please post the reply in a way that i can see it.


thanks in advance.

yes all the instances are in the same catagory. for example....the transformer is seen 6 times in the "processing" category.

I have installed MVS version. But i have a problem.....i see the same component multiple times....for example a transformer is shown six times in palette...could anyone please tell me the reason. Will this problem is solved if we can overwrite files by reinstalling the MVS Version.

Thanks

can anybody tell me how you are doing string replacement in mainframe job?

for example....if a password column had six characters .....i need to replace it with 6 '*'s .



Thanks in advance.

can anybody tell me how you are doing string replacement in mainframe job?

for example....if a password column had six characters .....i need to replace it with 6 '*'s .



Thanks in advance.

i already specified at the start of the discussion that the random numbers should not to be repeated.

and also i am able to see only forst 2 lines of ur reply......i dont have any membership to see the other part. please allow me to see that.

no...........it has millions of records

i want to do a swap of rows. so that the records are placed in the random rowid instead of the original one. this is a kind of masking iam doing.

one more thing.......i cant predict the row count.....i comes as an input to the column generator. so i cant set the limit manually.........how i solve this problem?

it is working.......but it is repeating some numbers......how i can avoid this?

iam sorry......i donno regarding which stage u r talking. i cant see anything in the column metadata of this stage to select as random and to set the value.

can u please be more clear.....iam using colmn generator but it is generating the numbers serially starting from 0 not randomly.

for example: i got a total row count as 10000. I should be able to generate random numbers from 1 to 10000 which should be unique......should not be repeated. for example it may look rowid randomrowid 1 566 2 492 3 9999 4 10000 5 892 . . . . . . 10000 1 and so on.................

can anybody has c++ routine that takes total row count and generate random numbers in that range and should go to the output of the transformer. Or is there any other way to get it.....


any hints plz.........