DSXchange

Hi All, I am mading Sequencer jobs for initial loading for DW. But I have a problem with Sequencer job. Actually, I have entry point sequencer job. the sequencer job has child-sequencer jobs. each child sequencer job has server jobs or parallel jobs. when I force to run entry-point sequencer job. bu...

Hi I tested this functionality on SMP. but I used memorywindow concept for HPUX 11.x This concept is announced at releasing for HPUX 11.x . How to overcome limit of memory usage for 32 bit application. (I just read an article.) Anyway, It could be applied for HPUX box. so I had a enterprise job used...

Thank you . It's so helpful.
[

ArndW I checked Scratch space for each node. But each pointed disk area has a lot of free space. Each Scratched Area has 300GB left more. Is not It enough? If so, Please give how to calculate the amount of needed disk space. and Other thing is, When I decreased Restirict memory limit to around 60 (M...

I want to use px sort stage on HPUX.but I found something wrong with using memory. It means that HP Box hase 60GB free memory. so I wanted to increase memory usage to around 1GB. (Parallel Degree = 12) But When I set Restrict Memory Usage Parameter to 1000 (MB). But this job is aborted with some mes...

Hi Ray I checked dictionary, so I chance "glue" to "Guru". Is it right? Thanks for your comment. I already came POC with Ascential. but I did not find good workaground.. If you have any information in detail about Parameter tunning. Please Let me know it Thanks Dhwankim Hello Dae...

Hi Glue. I wonder what is different between Oracle Enterprise Stage with Write Option(Load) and Informatica Bulk Insert option. Some Developer said Informatica Bulk Insert Option is not using SQLLDR Utility. but It's functionality is similar to Oracle Enterprise Stage with Write Option(Load). but Pr...

I try to keep my hands to myself. Is there any reason to use Syncsort with DataStage PX? I thought the parallel sort was good enough and you have support for reading sequential files from multiple nodes or using a sequential file as a lookup source. Why I need to collaborate with Syncsort is My Pro...

Hi Glue. I have embarrassed because of unsupporting SyncSort at DataStage 7.5 As I know, DataStage PX supported Syncsort on previous release. Anyway I want to use datastage PX job with Syncsort on DS 7.5 rel. If you have some information related to this environment. Please Gime your hand. I would ap...

Hi gurus. I need to know column information on some link by subroutine. but I could not reach that information. If I got this column information. I'll made some Unix Shell code. suppose that job is coposited like that sam stage(named Sam1) =====> 1stTransformationStage(T1) =====> 2ndTransformationSt...

Hi gurus. I want to extract data from unisys Mainframe. They(my customer) said this unisys system is using 9bit data format. but I have no idea about unisys. So I want to know how extract from 9 bit data to open system. and How to support this process by datastage. How to convert 9bit format to 8bit...

Hi All I tried to use Oracle Enterprise Stage with Write method Property set Load so I want to handle detail with some additional properites. Disable Constraints as Additional Property set True after all, I want to make exception table with Exception table properties. but Nowhere is Exception table ...

Hi All, I am now converting server job to px job. then I do not know how to change some derivation in transformation. In Basic Transforamtion Trim(Oconv(@DATE-1,"D-YMD[4,2,2]"),"-","A") I want to change all basic transformation to PX transformation for speed. Please Let...

Hi Gurus. I have a problems with handling Simplified Chineses with DataStage. Actually DataStage is installed on Korean UNIX Server with NLS KSC5601. My Default Character map is KSC5601. But I need to extracet Chineses Data from Remote ORALCE. They(Chinese DBA) said their ORACLE is setup with NLS ZH...

Hi Gurus. I have met the problom in handling a modified timestamp file. Originally, this data are from DB2 at MainFrame using db2 unload utility. so when unloading, date files are trimmed mili-second part. So My Customer said that file has "year,month,day and hour minute second " formatted...