DSXchange

Thanks for your suggestions and this will be helpful a lot for me.

Hi,

We are planning to migrate datastage 8.7 version jobs to informatica.
Can someone share any ideas or steps to save the time during the migration process.
Saving time :i.e. Exporting/ importing the meta data.

Thanks for your help.
if we will convert from Unicode to ascii - 256 that require to change in datastage job metadata on output stage.

As per the requirement need to read one of the XML file and separate same XML records into another file based on lookup file. Input <Mid> 230 </Mid> <Memname>Frank</Memname> <Memaddr>123 Ave Raod</Memaddr> <Memphone>234908789 </Memphone> <Mid> 130 </Mid> <Memname>James</Memname> <Memaddr>6780 Old Tr...

As per the requirement need to exclude matched records if any source employer value will match with reference table employer value. i.e. source input --------------- 203040 302340 103040 Reference table -------------- 203040 302340 Output should be : 103040 and values which match with reference tabl...

Hi, We need to write XML file into queue and planning to place whole file data into queue. Designed job like (Reading input file) External_Source---->MQ stage. Source program given --->cat cust.xml Issue is every record from XML file creating separate message and our requirement is we need to write ...

You mean we can send XML messages directly from sequential file stage to MQ server with varchar(20) ? Can we directly place XML file on MQ server using below approach. Extrenal_stage-->MQ STAGE . Our requirement is need to send data from DB2 to queue in XML format. For this we are first creating XML...

Hi Eostic,

You mean we need to load data on MQ through XML stage?


(To read XML file) Folder stage---->XML Stage---->MQ

Above method will work ..also we are using datastage 8.5 and in this case we need only MQ clint software on datastage box right.
Thanks for your help.

Hi, We need to push messages on one of the MQ queue. We are planning to push messages through WebSphere_MQ_Connector stage and issues is message should be in XML format contain headr,detail records. First we need to generate XML file then pass that XML into WebSphere_MQ_Connector stage? or directly ...

As per the requirement we need to make join on two columns with one column. e.g Table A Table B CID CID1,CID2,CITY 230 230,560,NJ 450 450,340,WC 560 340 Output ------ 230,NJ 450,WC 560,NJ 340,WC Source column have only one column and target table data presented on two columns and we are unable to us...

version 8.5

Hi Ostic,

We have implemented some java code and able to make HTTP call out for above mentioned URL and please let me know the process for using java class code in datastage.


Thanks,
Raju N

Hi, We need to call web services through datastage and designed job like below. seq---->Web_Services_Client Through seq file we are passing the data which required to call web service request and all values has been set on Web_services stage. But when running the job getting below error. Web_Service...

Thanks Eostic for quick replay.
We need to call java class code through java client stage or is there any other process we need to use.
Another thing is I don't have any idea on java and just want know is there any other approach we can implement with in datastage to make http call.

Thanks,
Raju.

Hi,

As part of the requirement we need to call one of the HTTP url after loading data into database table.

http://100.266.53.14:1234/QPgetmemberHttp?source=PHX.

Please let me know which stage we need to use to make http call from datastage.

Thanks,
Raju