DSXchange

Have you checked the link ordering and also make sure that your data should not be repartitioned in any of downstream stages after funnel.

Ok, here it goes:- Source----sort stage-----transformer------link0 --funnel----target -----link1--- In sort stage,on input tab define partition as hash Key-empwmail usage-patitoning Emppath usage -sorting In stage tab :- Key-empmail Create key change column-true In transformer stage define three sta...

In case of file pattern,datastage perform just like unix "cat" command,since all the metadata of files are same,so its read bunches of the files togather.

For me it looks like interview question,it seems it has been asked same question to many people recently.

Hi,
I think using sort,transformer and funnel stages you can achieve this.
Hash partiton on email and sort on filepath and emailid columns and use key change column. Use transformer stage and split keychane:0 and 1 and funnel it after.

Hi,

Thanks for your reply,but unfortunatly we cant use target as database.

Hi, Is there any parameter setting in MQ connector stage such that i can design a job with soruce as MQ connector and target as File. MQ connector stage has to always look for a message in a queue and at a time only 1 message will be landing to the queue. I have seen some posts here but it did not h...

Hi,
Column that need to be converted are static or dynammic?

Hi Everyone, Thanks for your input.My client is very rigid and they dont want to change their flow so we cant directly schedule our jobs in appworks. We have only this option to look for trigger file which is given to DS as MQ message and then need to trigger out sub sequence.For loop we have given ...

Hi Chetan,
Thanks for your input,but we cant use unix script here to create a loop,this we are doing in job sequence.

Hi, I have a requirement where i have to design a sequence job which will keep on running and it will look for trigger file. Trigger file will be created by another master job,which has source as MQ. This job will also keep on running and as soon as message land up to the MQ it will create trigger f...

Hi,

I have a requirment to convert text data into hexadecimal,for that I am looking for basic transformer stage in parallel job,but I can't find out this in datastage 8.7.
I am just wondering, Is it not available with the IIs 8.7 client installation.

Hi,

You can design your job in this way:


Thanks
Prasoon

Hi All, I have a requirment to develop a job where sourse is MQ connector stage and target is a file.I need to create file of same name as MQ payload message.If multiple messages are coming to MQ togather,job should run with one message at one time and should create a file and then for other message...

Hi All, After doing some investigation i am able to resolve this issue.As DATASTAGE_JRE and DATASTAGE_JVM enviorments are not required for IIS8.5 and above,so i removed from .profile but before we started our datastage server with some modification in dsenv and even after removing these variables fr...