DSXchange

We were getting ASYNCHRONOUS_NETWORK_IO lock SQL server. After Working with IBM,Microsoft, Network Team we resolved the issue. This is due to some "Advanced" network setting of Microsoft Windows Server 2008. This is what we done 1. In the Property list, click TCP/IP Offload, click Disable ...

Its not NOTHING ..Both SQL SERVER environments have differences.

Below are those differences
DEV:

OS:-WINDOWS 2003
Number of CPU -2


Stage :

OS- Microsoft Windows Server 2008 Enterprise
Number of CPU-8

Create sequence number for each of your record starting form 1,

then get maximum value of ID from database which already present there and then add generated sequence number with max value form table.

Which you can use as your unique id.

Regards,

Even if you gave multiple execute command stage in a sequencer it may not work parallel especially if you are calling same script with different parameter. For that if we create this execute command as separate seq job and if we call it as Job activity it will work in parallel. Of course we can use ...

Okay Lets take it in a different way, so your requirement is if any alphabet present in your input column then it is valid. lets do in 3 steps: 1)convert $ in the input empty. 2) then Covert all alphabets present in the output of 1st step to $, one suggestion instead of writing all alphabet in both ...

For this requirement i feel its better to go with Quality stage if u have. Write a pattern like *? and *^ *? Which will satisfy only if your input contain Alphabets. *^ Which will satisfy only if your input contain Number. Any by using this ruleset in Standardize stage you can achieve output. Regards

Sort by phone number and Name , then for each of that group u can have specific GROUP and FAMILY.

Try it out , you can do it easily

I think his issue is

He is trying to call Multiple script from datastage sequencer in parallel But Datastage is not doing so as he expected.

You can create Separate JOB ACTIVITY for these scripts and call it from your main seq it will work paralley..

Hi
What is the exact error you getting.
It can be of various reasons like -duplicate value for key,Look up Fail


Regards,
Rakesh

Join and Merge will also provide you all the matched output ,i.e for the duplicate(multiple) key values if present in ref file also.

Where as in look up it will give you only the first match!!!

Yes i do want to loop my entire input record for each of the ref record. Since i am using using AUTO transfer mode for ref link i will get the inpRecord along with its matched refRecord. Doing this through Transformer was my initial approach,But which was giving lot of issues related to performance ...

Hi Ray, In this case we may have same ID value repeating a millions time in same Ref File as well as in the Input file.So if we perform Join it will create HUGE volume of data for comparison. Which inturn may cause performance issue and will fill scratch disk space as well Dataset space. That is the...

Hi Guys I am having a requirement to do "Like" Operation between data in two files. Since data is large i wrote an Build Op to do the operation.Which will work as Join stage INPUT DATA File Format InputCode| Input_Record REF DATA File Format RefCode|Ref_Record Matching Condition If InputCo...

I got it!!!

When we used UTF -8 in the Output sequential file with output column as Unicode its giving the required output.

For which we have to use the function Char(Decimal value of the unicode character ) in the transformer.
ex:char(8486) for Ω


Regards,
Rakesh

Hello All,

We have a requirement here to Convert data to the Unicode Greek letters.

For Example:

If input data='ohm' then 'Ω'

But when we type 'Ω' in transformer stage its showing as '?'.

Is there any way to do it with NLS setting or any other way to handle this

Thanks,
Rakesh K