DSXchange

Merge can be used ideally for anything .. A seq file, a Dataset, etc...
Anything with data can be used to merge. Although I have not tried everything. But the manual would say which ones are not compatible with merge stage.
Join and Lookup stage are classically used to make joins as it says by name.

Ray,
Wouldnt he require federate links to link between the two databases?
Correct me if i am wrong.

A MAY BE TIP: I have tried it
when you hit the View Data button, an Error window pops-up. Check mark the VIEW ERRORS ONLY radio button, if you see nothing below in the job output, then there is no data in the file. If yes, then there is some problem in your parameters.
But this wont be valid always.

You gotta try it to know it!!
I've experienced it and know the manual is right :D

You can develop a job in PX using multiple instances. If the target is same and the source file is of same TYPE(ie, seq,xml,etc). Then load the records schema file that overwrites any settings in the format and columns tab. You can have multiple record schema files of your source in your unix dir. T...

meena wrote:I have a job designed in which from transformer there are two output links given to a sequencer as inputsMeena

What does this mean ?

If you are using one sequential file stage, you will get one file created at your target path.

Please restructure your question!

The commit frequency as mentioned by Andrw, would help you acheive the goal. The default I beleive is 1000 rows.
Most of the time you dont have rollback privelages, so decide before you commit anything.

My experience gave a failure on Lookup file sets , as i had high volume of data. So we had to go for File sets.. but very bad performance

heres the website
http://www.biblioscape.com/rtf15_spec.htm

click on the blue text of Arnd's reply.

try creating a simple sequencer job, just a couple of job activities linked with each other. and try to compile them.
from the error msg you are getting, it seems like your DS_JOBOBJECTS hash file is corrupted. try the test and let me know what happens.

naveen is right. use the merge stage to achieve your goal. if you use a hash file, depending on your key, the duplicates will be removed. check and make sure you have those two records in the hash file which i highly doubt, as your key would be one of the first four columns, which are identical. has...

what is the max number of columns you have? why i am asking is because, if i were you i would do as follows, * have the input file going into a transformer * have n number of links coming out of your transformer (n = num. of columns) * inside the transformer apply your logic eg: lets take your first...

The best way you could go about accomplising that is have a wait for file activity waiting for that file, have a link go out of it to JOBA, similarly do this with all you jobs make the links coming out of all those four job activities to a sequencer. inside the sequencer, choose the mode as 'ALL' fr...