DataGenX - Atul's Blog: Administration

Showing posts with label Administration. Show all posts

yet another In Memory DataBase - MemSQL

June 23, 2018

Writing this post after so many days, yet another IN-MEMORY database is in market which tag line promised with "The DataBase for Real-...

Mongo DB - Installation and Configuration

January 14, 2018

MongoDB is an open-source document database, and the leading NoSQL database. Written in C++. MongoDB features: Document-Oriente...

How to get DataStage Project Settings

March 05, 2017

DSListProjectSettings.bat is used to report all available settings of existing projects. USAGE: DSListProjectSettings <SERVER> <...

PDF Split & Merge with Perl

February 21, 2017

Sharing two utility scripts (Perl), which can be used for extracting only few pages from a PDF file and also for combining different pdf fi...

Import the jobs from DS windows client #iLoveScripting

December 07, 2016

As we have discussed a script which can export the datastage jobs from your client system ( http://bit.ly/2frNPKj ) likewise we can write a...

Script to Auto Compress the System Log Files

October 12, 2016

This Script is originally written by " Andy Welter " to compress the linux system log files. I have modified it to work better. Y...

#3 How to Copy DataSet from One Server to Another Server

August 03, 2016

This post is third and last of How to Copy DataSet from One Server to Another Server Series We have generated a populated a dataset and i...

#2 How to Copy DataSet from One Server to Another Server

August 01, 2016

This post is second part of How to Copy DataSet from One Server to Another Server Continue....... After generating the dummy dataset,...

#1 How to Copy DataSet from One Server to Another Server

July 30, 2016

Hi Guys... I've been asked so many times that how can we move/copy one dataset from one server to another So here is the way which I ...

Tuning SQL Statement #4

June 07, 2016

Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...

Tuning SQL Statement #3

May 23, 2016

Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...

Tuning SQL Statement #2

April 27, 2016

Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...

Tuning SQL Statement #1

April 26, 2016

• Try to use explicit columns and try to read columns in index orders if possible, even to the point of reading indexes and not tables....

ETL Development Standards

March 01, 2016

These development standards provide consistency in the artifacts the ETL developers create. This consistency improves testing, operationa...

Subscribe to: Posts ( Atom )

DataGenX - Atul's Blog

yet another In Memory DataBase - MemSQL

Mongo DB - Installation and Configuration

How to get DataStage Project Settings

PDF Split & Merge with Perl

Import the jobs from DS windows client #iLoveScripting

Script to Auto Compress the System Log Files

#3 How to Copy DataSet from One Server to Another Server

#2 How to Copy DataSet from One Server to Another Server

#1 How to Copy DataSet from One Server to Another Server

Tuning SQL Statement #4

Tuning SQL Statement #3

Tuning SQL Statement #2

Tuning SQL Statement #1

ETL Development Standards

Random Posts

Follow Us

Facebook

Recent Comments

Follow by Email

Popular Posts

Recent Posts

Random Posts

Popular Posts