How to iterate MongoDB Cursor in Python - Intermediate I
Atul Singh
January 01, 2019
Whenever querying on mongodb, always store the output into a variable, called cursor, before performing any operation on data. It will keep...
Showing posts with label Function. Show all posts
Showing posts with label Function. Show all posts
Tuesday, 1 January 2019
Friday, 11 December 2015
DataStage Scenario #11 - Get numeric or alphabets only
Atul Singh
December 11, 2015
Goal - Extract numeric part and alpha part from a string as below Input: Source ATUL1234 SINGH374 I23S ...
Friday, 30 October 2015
UpCase and DownCase String Function : DataStage Transformation
Atul Singh
October 30, 2015
Downcase(column): This function converts all the input character to LOWER case where input can be in any case. input =...
Wednesday, 28 October 2015
Left and Right String Function - DataStage Transformation
Atul Singh
October 28, 2015
Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string fro...
Monday, 21 September 2015
DataStage Scenario #5 - Oracle Rank & Rownum
Atul Singh
September 21, 2015
Scenario: a. Design a job where we read the data from squential file. b. Analyze the data into job and generate these 3 columns E...
Friday, 28 August 2015
Datastage Transformer String Functions - Index
Atul Singh
August 28, 2015
Index(String, Substring, Occurrence): It will returns starting character position of substring. We can use it as a 'grep...
Saturday, 22 August 2015
VLookup in MS Excel
Atul Singh
August 22, 2015
We all agree on this, we have to use MS Excel in our day to day work whether it is technical or not. A day before I came across a Excel F...
