Skip to main content

Posts

Note on Regular Expressions

 For more detailed and interactive analysis Go to regexr.com \w   :   Stands for matching any word character \d    :   Stands for matching any decimal/number \W  :    All except word \D  :     All except decimal *    :     Quantifier type---matches 0 or more of the preceding token +   :      Quantifier type---matches 1 or more of the preceding token [    :     Start of character set; [ABC] will match all the occurrences of each character(case sensitive) [^ABC]    :    Negated set; will match all characters except A,B,C. [A-a]        :     Will match all characters falling in ASCII for A to a [ASCII(A),ASCII(a)] .(dot)        :    Matches any character except line breaks.
Recent posts

Suggested Upgrades in Xceptor Data Hub

 1) An option for a Message Processor to be queued / dependent on occurrence of another Message processor can be done. 2)Ingestion of a certain file due to triggering by the creation/deletion of a certain file . 3)Direct way to output data from a translation table 4)Not all actions need to be exhaustively mapped for each processing rule in Message Processor.

Doubts/Challenges/Issues in Xceptor 4.2

 This article will be on my doubts(may be misunderstandings) and some issues I faced to dearth of discussion forums on the product so I am open to criticism and views of other solution developers on Xceptor. 1. While having multiple processing rules on a single message processor, if I mark all the rules with the same Priority, then what is the logic(is it they all happen simultaneously or there is queueing).On my observation, the rule which was made earliest runs first, if one rule is edited then that rule will happen at last. I need observation from others on this issue. 2. No way to generate a report from a translation table unless you have the list of the Keys(or single key if multiple mapping is enabled but there's a problem with this approach ,I have mentioned the solution in another article 3.In case I have a file which is produced at some stage and needs to fed for a subsequent stage then deadlock happens(the file is produced at the folder/output directory but the writing th

Interview Experiences on Xceptor

 I will be discussing here the questions which I found to be less logic probing and more on skewed knowledge on Xceptor. If all the functions of Xceptor are noted then for a person who is well with Higher Secondary mathematical logic, it is easy for the person to make out a solution. The tool is easy to understand and can be picked up within a few months, as it depends on the variety of problems/cases . I am limiting the logical and interesting things on the article on Use Cases Now coming to Interviews I was once asked by the interviewer to enumerate all the options and functions available on a specific "window" in Xceptor. This was a face to face interview and I had no way except to say that I could not remember. Coming to another one , this one was on Zoom video call but the interviewer didn't share his screen and I was not able to understand the type of input file and its data structure so I asked if there was a Primary/Composite Key but to my surprise he got infuriat

Use Cases for Xceptor 4.2(continuous updates)

 I will be enumerating certain use cases which I have encountered , these will be varying and no similar use case will be repeated. 1)Full Reconciliation: In most cases you will be reconciling records from two sources,Although a different tool(reconciliation hub) is offered by WSI but this can be achieved in Data Hub by using Translation Table(an alternative is there without it but it is slower) Say for example you have n(A)=10(number of records in set A) and n(B)=15 and the common records between them be 7{n(A-intersection-B)=7}I could not find the inverted "U" :( and I dont know how to paste a Latex code here else it would have been better. By Set theory we know that Atleast(A,B) or n(AUB)=n(A)+n(B)-n(A-intrsct-B).Therefore n(AUB)=10+15-7=18 records. if you do have to reconcile more, like 3 files then n(AUBUC)=n(A)+n(B)+n(C)-n(A-intrsct-B)-n(A-intrsct-C)-n(B-intrsct-C)+n(A-intrsct-B-intrsct-C) I hope by now you have come to know the general formula for N sets that add the s

Introduction to RPA tool:Xceptor-Version 3.6 & 4.2(will be updated)

I have worked only on Xceptor Data Hub 3.6 and 4.2 hence its limited to these products from WSI (Web Services Integration)  Finding resources on this tool is problematic, there's no forum or any community edition for a person to learn / discuss.This is web application based (web server) catering to the automation of operations related to Banking and Financial Services Industry. That's how it is marketed,  I was fortunate to work with this tool while serving one of the most revered Investment Banks but coming from a pure IT services and software company, Knowledge Transfer and Management was not upto my expectations,In fact there was a unit named as RPA Center of Excellence(COE) who had the responsibility to provide training,troubleshoot,upgrade the products by contacting the vendors. But every-time I approached for a detailed manual for this "Xceptor Data Hub" product, I was handed with a roughly prepared PowerPoint presentation which was said as the one prepared by t