DSXchange

Hi folks, I have a job starting from two datasets, which are going to be joined based on two key, SEQ and DATE. Essentially I hash and sort them on sort stage before moving to join stage. My doubt is since I already define SEQ and DATE as keys from both dataset, I am not sure if they are already bee...

Thanks Ray, just been this project few weeks I will do more study on that.

Hi All, In my job, I use Oracle Enterprise Stage as source instead of ODBC, and replace lookup stage with diff stage, what I found throgh monitor is that the Elapsed time is very close, but the CPU percentages are less, is my observation correct? does this help to improve profermance? By the way is ...

Thanks so much Craig,
Sorry for my green , do you mean only table itsself is partitioned, we can use this option, and index has nothing to do with this?

Hi All, I was trying to testify Partition Table option in oracle Enterprise stage for performace tuning, I wrote a simple select query and insert to a dataset the issue is that the number of extracted rows got doubled after I gave the source table as a partition table, I am sure there are several in...

Thanks Ray & OddJob

Hi, I have to change newline characters to space since one record has multiple lines from input file like ----------------------- 1 2 3 4 5 6 3 5 ----------------------- 2 4 6 6 7 8 7 7 ------------------------- In Sequential file stage I used sed 's/\n//g' which is not working without knowing the m...

Thanks Ray, Could you tell me where should I put this code to, Sequential file stage?

I am trying to retrieve data from unix file through Sequential File Stage, the layout of file is like following 1....2 ......3 ........165......200....257 ------------------------------------------- 1; 235; 9090;.... 0000; 2; 353; 8849;.... 3666;... .... ....7780; 3; 536; 4672;.... 5745;... 8383; it...

Hi,
We have a one single row from source table as a daily record, how to make 24 identical rows as input to target table, which requires data showing like hourly.


Thanks,

Yan