DSXchange

I have the following setup: DS --> Lookup --> SeqFile ^ \ | \lnk2 | \ LookUp DS (Rejected records) FileSet When I compile, I get the error: Error: Reject link Lookup.lnk2 is not allowed unless an input reference link failure property is set to 'Reject'. One solution mentioned in this forum is: &quo...

As all the xfr's are doing same thing, how will datastage split the load on each of the xrf in the job shown. Will the buffer size have anything to do

I have a job pulling data from Oracle tables( 50 million records).It is just a trasfering into another table with little modifications ( like date formate is changed in the Xfr). I used the IPC stage as oci-----Xfr----IPC----collector ---IPC--oci -----xfr----IPC--- -----xfr----IPC--- 1) In Job Prope...

yes we need to sort the data that comes into the final target table. That's y we are using the Sort Merge in the collecting.

What u say is if we use round robin we will get job much faster than sort merge if we dont need to sort the data.

When i use PX with Round Robin it is 45 min

and I m runnning with sort merge I will let u know

How exactly will in the Sort Merge works in selecting the keys is are any preference when I have to 3 keys , which key comes first


Thanks in Advance.

Thanks Guys

I think now I know how to copy !!

I'm new to Datastage. The designed some jobs in my computer( personal computer) Now I want to copy all the jobs from my computer to another computer, I dont have any network connx to that computer to share the files in the network. The only access i have is a CD writer so i can copy into a CD and du...

Hi, I am getting data from a seq file where I am sorting it using sort stage and sending it back to another seq file. This is very simple job. seq-------Xfr-------sort------seq When i did it in server job it takes me 7 to 8 hours when there is no extra load on the server , when i use the PX it takes...