DSXchange

Actually after posting the topic, I could find a solution for this topic which I did not find earlier. I could see a status report now when clicked the performance analysis on top tabs after selecting the option record performance in job properties. Report looks very good as a diagram but for some r...

Hello,

I was trying to check the performance analysis of a datastage job in 8.5 using the performance analysis tab in the data stage director for a particular job .

It says no performance data files available, can anyone please suggest me how to check the performance for a job.

Thank you

Hi John, Thank you for the information and links. Actually we are looking for something which can mask the names on an image as Chulett said ex: name on a license. The links suggested by you seems to be masking images . Correct me if I am wrong Hi Chulett, That is what exactly we need to do,we can f...

Hello, Our team does data masking for data from different data bases. Is there something from IBM where we can mask or replace data on images like credit card, license. Need to figure out where there is data on the image and replace it with some other word, like finding the pixel place and mask or r...

In the below scenario I was trying to partition only state , can you please suggest how to partition only one field and after that I used sort stage to sort state code and order.

Thank you!

Just to be clear my requirement is Before: 1)John, 123 rew dr,chicago, IL 2)Anthony, 456 qwe dr, springfield, IL 3)Ronny, 789 hjg dr, queens, NY 4)Joseph, 345 kli dr, nyc, NY After: 1)John, 456 qwe dr, springfield,IL 2)Anthony, 123 rew dr,chicago,IL 3)Ronny, 345 kli dr,nyc, NY 4)Joseph, 789 hjg dr, ...

Thanks very much!

I will try the same scenario and let you know

I have a source file with 1M records which has addresses in it. Please provide me an idea to shuffle the addresses with in the file and also the addresses should be from the same state. I sorted the state_cd field and generated a key column to identify the state change. Can any one help me out the n...

Hello,

We are using 8.0 version of datastage and trying to connect to SQL server 2008 with windows authentication.

Can we get connected or we need only SQL Authentication?


Please provide your input

Hi everyone, I used random function in transformer to generate random numbers and after that I am sorting them in ascending order so that the particular rows linked to a particular random number will not be pulled same each time. i.e my requirement is each time I need to get different records to be ...

Hello, I am developing a sequence job and to pass the parameters to the parallel job which is being invoked from this sequence job. So in the process of getting the parameters I need to cat two files simultaneously for which I used cat file1;cat file2 using execute command. Below is the format of th...

I found 4 types of loop in the help material, mentioned below. Loop example: converting a single row to multiple rows Loop example: multiple repeating values in a single field Loop example: generating new rows Loop example:aggregating data Can you please suggest which one suits better my requirement...

Will try it with help files


Thanks very much!

All the field2 values are unique, so can I use the function?

From the below coding what I understand is save the first field2 record into a stage variable and then SaveInputRecord into the loop.

Is that right?

@ Ray So is it something like SELECT table1.field1,table2.field2 FROM table.table1, table.table2 WHERE table1.field2!=table2.field2 But the thing is I need to create a transitional file which contains all the shuffled field2 for the respective field1 and this transitional file should be used to do j...