DSXchange

Thanks sreeni for the information, in that file what kind of information do i have to add. please can you provide me the sample file.

Hi Chulett, You are correct administrator will do all these thing, with curiosity raised a request.
Thanks

Hi, When a sub sequence fails I have to send a mail for that iam using email notification activity. Provided necessary parameters like server name, senders and recievers mail ids. But i am not receiving any mails. Do I have to configure SMTP server at UNIX SERVER. If I have to configure what are the...

It has happened only once and I had seen this warning for the first time.
Thanks

Hi All, I am getting this kind of warning. main_program: When deleting data set /opt/datastage/projects/TEST/DWRCPS_DIR/STAGING_FILES_DIR/xyz.ds, previous delete attempt not complete; removing /opt/datastage/projects/TEST/DWRCPS_DIR/STAGING_FILES_DIR/xyz.ds.being_deleted in order to proceed. can thi...

Thankyou very much Chulett & Roy for you valuble suggestions. Please enlighten me how to check the condition and execute the job3 and job4. what I understood is in nested condition assumption that x is my job parameter if x = 'region1' then ____________(what statement should i give here) else __...

Thanks for the suggestions, I am little bit confused here.

I shall put all the jobs in one sequence 1,2,3,4,5

if r1 then 1,2,3,4
else
1,2,4,5

how to achieve this using nested condition activity stage.
Please provide me an example to go ahead

We have 5 jobs job1, job2, job3, job4, job5, here is the requirement job1, job2, job3, job4 needs to be sequenced for region1 and job1, job2, jo4, job5 needs to be sequenced for region2, what we have done is, we created 2 sequences for 2 regions. Please advice whether we can do it in 1 sequence for ...

Using DRS stage

Hi Everybody, I have to load data from a dataset file to a oracle table. There are no transformation rules(i.e., its a column to column mapping). In dataset we have 5,07,120 records and this needs to loaded into oracle table. In my production environment we can have 6 times of the record count (abov...

Hi, In my master sequence, I have sub sequneces. for example. master sequence contains -->sub sequence 1 -->sub sequence 2 -->sub sequnece 3 when any of the sub sequence is aborted, the status of the subsequence status in director is aborted, but the master sequence status is 'Finished'. Triggers ia...

Hi, I had a requirement, where my source is a sequential file and it is pipe delimited. In source file description column has a value with pipe. for example : second_column has value car|care record looks like this 1|car|care|UK where car|care is a single column value. Problem here is when it is rea...

Hi All, I have simple parallel job drs stage --> transformer --> seq. When the values like hostname, username, password are defaulted then the job is executing succssesfully but the same jobs executed wtih project leve paramaeters (user environment variables) job is getting aborted. In log we are ge...

Thank you very much, issue resolved.

Hi All, I am reading data from an oracle table and writing to a fixed length file. DRS stage --> Transformer --> Sequential file Properties for file, Final Delimeter = end Record Delimeter = UNIX newline Delimeter = none quote = none job is executing successfully, the issue is with data. iam getting...