DSXchange

I cannot run an after SQL statement on one target table as other might be still running. I want this to happen only when both the operations are done completely and in the same job

Hi All, I have a requirement where I need to perform an action after operations on all target stages are complete like Eg Source ----> Transformer ------> target 1 (target table) ---------> target 2 (reject table) I want to perform an action after both operations to target1 and target2 is complete w...

Thanks Andrw for your swift reply. Let me try and I guess I need to add this in the filter options and with all the last columns in the columns tabs. I have also tried one more option, I don't know if it is the best way to do it and are there any limitations in it? Read entire string as one record i...

ArndW, Thanks for the reply but I could not understand. Did you do it in scripting while sourcing the files in UNIX or in Data Stage?

Hi All, We have requirements to load fixed length file format in our ETL environment and have found an issue which I don't know it is a file format issue or Data Stage issue or issue while FTPing the data into our landing area. Would require your inputs resolving it. We have file with metadata like ...

Hi, I get few error messages when I use basic transformer in the parallel job - "operator terminated abnormally received signal sigsegv" APT_PMsectionLeader(1,compute), player 2, Unexpected exit status 1 APT_PMsectionLeader(1,compute), player 6, Unexpected exit status 1 APT_PMsectionLeader...

You need to have your client Windows code page set to 936 (for Simplified Chinese) or 950 (for Traditional Chinese) before the DataStage clients will be able to display or enter your Chinese characters correctly. On XP this is normally done from Control Panel/Regional and Language options/Advanced/...

Hi everyone, I have a requirement where I need to load the Chinese characters from a file into an Oracle table using DataStage server job and it works fine when the NLS is set to UTF-8. Now, the problem is when I view the data from the sequential file stage or from Oracle table, I am unable to see t...

Will there be any disadvantages if there is an Unix script running in infinite loop and once the file is found it will trigger the main process and after the successful completion of the main process, the file will be deleted and process will continue running in loop for 24/7. Do let me know any oth...

Yes Chulett, I am still thinking of any other ways of doing it and meanwhile expecting various suggestions from you people. Basically I want to achieve the trigger based mechanism in DS with OS being UNIX. I got one solution of running the script in infinite loop as and when the file is processed , ...

You could use a Sequence job to and schedule that. Set up the wait for file stage to look for the touch file. Yes, we can use the DS wait for file stage but anyhow we need to run the sequence at one point of time to wait for the file and it will wait continuously till the file is available and I do...

Hi All, We need to design a system such as a job sequence which should be immediately triggered once a touch file (used to indicate the initial process is finished) is placed on the FTP server or some other common server. Basically we have a two separate process, once the first process is finished i...