DSXchange

I do have a look up in Job which has 5 keys. I need to compare 4 keys in hash file with that of 4 fields in source. The 5th field in hash file should be not be Null. How can I give Not Null in the derivation field for that 5th Filed inside Transformer. If we want to cpmpare it with Null , we can use...

I am trying find out the places in a project where a table by name EDWADM.STAGE_END_USER i used. When I used Usage Analysis, nothing is being shown though there are jobs which use this table.

Any thing extra steps should I take care.

Yes, I got it. My eyes are not working properly now-a-days

Is there any way to find out number of columns for an o/p link from a tranformer without counting manually. In my job I have so many Transformers and O/P links. While reviewing I need to make sure that each o/p link has same number of columns. Counting them manuall is taking more time as each link h...

My Bad, I didnt expand / View the window properly. I was able to see evrything properly.

When a Job is running, I tried to see the monitor in Director. To my surprise, I am only able to see the stages, but I could not see rows/sec; no. of rows processed in each link.

Any settings has to be chaged for this?

Have you tried right-clicking in the pallete, selecting 'Customization...' and then 'Reset to factory defaults'?

I clicked Reset to factory defaults

This is working now.

Thanks for everyone.

Ray,

The palette is totally empty. There is no single icon to expand to show all stage types.


The Stage Types branch of the Repository is complete and correct. It shows all Stages.It has 3 categories. All, Sequence & Server. And in those categories all stages are present.

The stages in my palette are missing. When I open a server job or sequencer, nothing is displayed in palette.

Is there any settings to make this visible.

Note: We recently upgraded DS 7.0 TO DS 7.5.2

Hi Ray, I added constraint @FALSE in the trasformer, now the time taken is 4 min 53 sec. Is it that fetching records scale up linearly?? Need a clarification on this. Craig, Is this not a problem? I think this is a problem, for loading 190,000 records into a sequential file it takes 5 mins (approx),...

Ray, Now I tested as follows: One Source which populates a Sequential File. There were 194120 records selected. The time taken for this job is 5 mins 47 sec. Other details : In toad the same sql took 8 sec to fetch 500 records. Array Size:100 CPU utilization for this job : 17.59% Interprocess Commun...

Has anyone started using 8.0 version (In Windows, AIX, Unix) release officially. Can you give me the details of how it is working if you are using.

When I did a "top 10" command, I got the foolowing statistsics. load averages: 0.96, 0.93, 0.66 14:52:00 242 processes: 234 sleeping, 5 zombie, 1 stopped, 2 on cpu CPU states: 77.0% idle, 19.4% user, 3.6% kernel, 0.0% iowait, 0.0% swap Memory: 4096M real, 1265M free, 66M swap in use, 8134...

When I did a "top 10" command, I got the foolowing statistsics. load averages: 0.96, 0.93, 0.66 14:52:00 242 processes: 234 sleeping, 5 zombie, 1 stopped, 2 on cpu CPU states: 77.0% idle, 19.4% user, 3.6% kernel, 0.0% iowait, 0.0% swap Memory: 4096M real, 1265M free, 66M swap in use, 8134M...

My update action is "insert only". I tried Bulk Stage now in Normal Mode with Maximum Recod number 100. The time taken is around 11 mins. So, there is no much improvement in performance. I heard that Bulk Load doesnt improve performance much. Even some of the threads say like this.. Any ot...