Jerome Rajan

0 %
Jerome Rajan
Staff Solutions Consultant at Google
Data & Analytics
  • Residence:
    India
  • City:
    Mumbai
SQL
Dataproc, EMR
Hadoop
BigQuery
AWS Glue
PySpark, Python
Data Pipeline Design
Tableau, Redshift, Snowflake
IBM DataStage
  • AWS Lambda, S3, EMR, SQS, DynamoDB, Step Functions, Cloud Functions
  • Unix Shell Scripting, Python
  • Oracle, DB2, Redis
  • Alteryx, VBA, Blueprism, UiPath
English
Tamil
Hindi
Malayalam
Marathi

Tag: datastage

February 25, 2018 / Technology
NGBR-00019 – Input Dataset 0 not present in design time information

NGBR-00019 : Input data set 0 not present in design time information. Extended field properties for this field will not…

February 25, 2018 / Technology
Replace Strings in DataStage

Trying to find a way to replace strings. e.g. In the string “chocolate”, I want to replace “choc” with “mock”….

February 25, 2018 / Technology
Generate Unique Counter in a Parallel Transformer Without Surrogate Key generator

Old but handy trick. @INROWNUM * @NUMPARTITIONS + @PARTITIONNUM Update – To start the series from 1, use (@INROWNUM –…

February 25, 2018 / Technology
LUTCreateOp and LUTProcessOp

DSxchange, every now and then, comes up with some very interesting discussions thanks to the DataStage gurus like Ray, Craig,…

February 25, 2018 / Technology
Aggregator Methods in DataStage (Courtesy: Ray Wurlod)

Here’s another favourite from DSXchange by Ray Wurlod Hash aggregation builds a hash table of results in memory. There is…

February 25, 2018 / Technology
What Exactly Are Hash Files? (Courtesy – Ken Bland)

I pasted this nice article by Ken Bland on my blog just for future reference. The original article can be…

1 2
Be Original
Would the boy you were be proud of the man you are?