DataStage Scenario - Design6 - job1

DataStage Scenario Problem -->  DataStage Scenario - Problem6

  

Solution Design :

a) Job Design :

Below is the design which can achieve the output as we needed. Here, we are reading seq file as a input, then data is passing through a Transformer stage to achieve the output.

b) Transformer Stage Properties

Here, Create a new column in output which contains the Occurrence of characters

and their derivations are -

Count :  Count(In_xfm.Name,'A')+Count(In_xfm.Name,'E')+Count(In_xfm.Name,'I')

 +Count(In_xfm.Name,'O')+Count(In_xfm.Name,'U')+Count(In_xfm.Name,'a')

+Count(In_xfm.Name,'e')+Count(In_xfm.Name,'i')+Count(In_xfm.Name,'o')

+Count(In_xfm.Name,'u')

Create a new column in output which contains the Occurrence of characters and assigned the StageVar.

c) OutPut File
Now, Output file have the output

Name    Count
Priya Awasthi      5
Diya Singh        3
Sunil Verma        4
Rashmi Arya       4
Neha Tomar    4
Akash Aggrawal    5
Anil chahal        4
Kashish Patel     4
Rashid Patel        4
Gopal Joshi         4



For More ---> VISIT THIS LINK