DSXchange

Hi all, In sequential file, in format tab, two options are there as record delimiter string and final delimiter string. whats the difference between them. In my job, I load 4 records to a sequential file and the format specified is "final delimiter = ~ ".. And in another job when i extract...

Hi all,

My ETL design is like this. I have to extract data from a stored procedure in datastage and then convert that data into xml data. I have to implement this in datastage. Please help me with some ideas.

Stored proc ----> copy ----> ?


Thanks in advance.

Consider this scenario. In sequence job, Job activity1---> failure trigger ---Sequence activity(any) Job activity2---> failure trigger ---Pointing to above sequence activity .. After this a terminator stage. Two job activities run in parallel. Second scenario. Two jobs run in parallel. And exception...

Hi all, I have a sequence design where if a job fails the sequence should be aborted. This can be achieved using failure trigger in the job and also by using exception handler. Whats the difference between these two. Is it good to use job trigger for job failure or exception handler is fine? Thanks ...

Hi all,

Funnel stage does union operation corresponding to the input and the output link or it does union all operation?

I want to remove duplicates as well, so i have doubt whether i have to use remove duplicates stage or not after that.

Thanks in advance.

Hi all, Please give clarity on "reset if required and run" and "do not add checkpoint" options in sequencer. I have so much of confusions in how its working. When i just give run in the job activities, the sequence job starts from the point of failure but when i give reset if req...

Does it happen again,as because the jobs are given in paralllel? Should i change it to sequential mode one after another to achieve this logic. Please advise.

Exception handler makes the sequence job to abort but it allows all others to finish successfully. Thats the problem. But if i give failure triggers for all the jobs and then sequencer(any) -->mail --> terminator it aborts the sequence with abort/restartable when i have given sequence as restartable...

Hi all, I have a sequence job, in which am running 8 jobs parallely. And i have given an exception handler ---> mail ----> terminator. For testing purpose i made one job to fail. When i ran the sequence job, all the jobs finished except the job with error. How is it possible. I have given a terminat...

Hi all,

I am getting the following warning for all many jobs. From today only it happens.

main_program: Failed to initialize job monitoring. Monitor information will not be generated.

Please advise.

U mean to say, there is no benefit in using array size option?

Whats the difference in setting it to 10 rows at a time and complete rows at a time then?

Thanks chulett and ray.

Hi all,

My query has some other clarifications like "out of memory". Any details on that.

Does performance improve if i set the array size to total records from the source as it completes transfers all the records to the target at a time. Or my assumption is wrong. It will execute parallely or in bulk mode when i select array size option.


Thanks in advance.

Thanks ray. Let me rephrase the question. I want to know where can i enable or disable that option. I got to know that if i use many lookups continuously for each reference table and if i enable operator combination option, all those will be combined and treated as one. If i disable it, i will get t...

Where can i enable operator combination in datastage?