DSXchange

Hi Mohsin for MQ, you may want to read from documentation of MQ itself that should give you a fair idea on how-to, what-to etc... while for XML you can read on these, just to avoid re-writing everything here, giving you pointers, use following links - http://pr3systems.com/blog/information-managemen...

As per error message it is all about "role setting" for the user(kirands99) which you are using.

It can be done DS Administrator, ask your admin to assgin you to developer user group.

It should resolve your problem.


Best regards

very simple one - Just to avoid re-writing everything here, giving you pointers, use following links - http://pr3systems.com/blog/information-management/datastage-xml-pack/ http://etlimpact.blogspot.com/2012/08/read-xml-file-in-datastage-using.html http://it.toolbox.com/wiki/index.php/Load_XML_files...

This error message looks like only with connection, where user is being kicked out and tries to recover automatically, this can be due to either timed-out issue (like 300 seconds) or it can be anything with the network settings for the DS engine box. you may want to try to handle this "reset of...

You can use following link for your export / import part and put it in a sh script and remember to invoke dsenv before executing command in script. To export - http://www-01.ibm.com/support/knowledgecenter/SSPT3X_2.1.2/com.ibm.swg.im.iis.ds.design.doc/topics/dsexportcommand.html To import - http://w...

Hurrey ... nice to hear.

Define a parameter at project level with blank value and use that in your sequence so that other sequence would not complain to define that explicitly... I think this should resolves your issue.
If not than please let me know for my learning

You may want to try re-indexing your project.

let me know if this resolves your issue.

Best regards

Hi above solution can be implemented but it depends what processing power you have with you and what data volume you have with you. Use option 1 , while you have less CPU cycle in datastage and good CPU cycles and less data volume. Use option 2 , while you have large data volume and moderate or good...

Hi In your audit tables you must have a static table where your all jobs/sequences must have an entry with a unique id. Use that id to pick up the row in the status table. If you are trying to have every run states then use date and status also in your where clauses in your update query. If you are ...

Hi It is expected behavior, it must create the exact directory structure the way jobs are stored in the DS project. But if as you said it is using the host directory also, that should not happen. Probably you may try to tune some setting which will allow you to use a project specific location for ea...

hi Bob

Plz check -

user-id which has been used to create the node directories - this may be dsadmin id or root or any users on the box.

user-id which is used to make communication possible between the grid architecture - this may be root or may be dsadmin id.

Cheers.

Hi

A column or flag or indicator which can find the the exact job-id, can be helpful.
Your audit job should be able to pick the job-id and then should be able to update the corresponding rows in the audit tables.

Cheers.

Hi If sparse lookup is not needed to fulfill the functional requirements. Then break this job in two parts. First part should have all the pull from the oracle databases, source references all of them, as they will run on one node only, because we do not have partition tables here. Write the data in...

Hi

Technically yes you can run multi instance job having surrogate key gen stage.

But functionally, if you want to use the same starting point for the key then okie, otherwise if you have to think for the logic which will be providing the correct start point for every instance.

Cheers.