We have moved to www.dataGenX.net, Keep Learning with us.

Monday, December 31, 2012

Wish you a very Happy New Year 2013 .. :-)


Wish you a very Happy New Year.. 
May GOD transform all your dreams into reality more beautiful!!! And as the
new year comes full of blessings, peace, health and prosperity!!!! 




till then.....
njoy the simplicity.......

Wednesday, December 26, 2012

How to find duplicate values in a table?



With the SQL statement below you can find duplicate values in any table, just change the tablefield into the column you want to search and change the table into the name of the table you need to search.

Monday, December 24, 2012

The Unix "SCRIPT" command : a command recorder




script is a standard Unix command that records a script of your interaction with the Unix system. Once it's started, it works "in the background", meaning that you continue to work normally, but the script session is dumping everything that shows up on your screen (more or less*) into some file. It probably would be better called carbon-copy. 

The most common use of script  is to document terminal session. By running script you log all the information displayed on your terminal. You can then print the log file or view it with an editor. In a way script is a specialized tee for the shell.

Thursday, December 20, 2012

How to Find the changes made by particular USER in DataStage :

How to Find the changes made by particular USER in Datastage :

Here is how -

  •  Go to Data stage Designer
  • from the Menu bar  Tools --> Advanced Find

Wednesday, December 19, 2012

How to set Default OS in Windows


Hi there...
Most of us have installed 2 OSs on our System and using Windows as default but most of the times the OS which is installed after be the Default OS so we need to select OS at booting time.

Here I am sharing How you can set Windows back as a Default OS....

Tuesday, December 18, 2012

Specifying C++ compiler settings for DataStage in Windows





Today I am sharing how to specify the C++ compiler settings for DataStage in Windows Environment. From last few days I also face a lot of issue with this :P so thought it need to share with you all.
For :  DataStage 8.x

Monday, December 17, 2012

FileSet in DataStage


DataStage can generate and name exported files, write them to their destination, and list the files it has generated in a file whose extension is, by convention, .fs. The data files and the file that lists them are called a file set.  while their storage places are diverse Unix files and they're human-readable.

Friday, December 14, 2012

DataStage Naming Conventions



DataStage Naming Conventions follows the guidelines of ETL Naming Conventions.

Contents

  • 1 Job Name Prefixes
  • 2 Stage Names
  • 3 Link Names

Thursday, December 13, 2012

DataStage Environment variables




1 Buffering 2 Building Custom stages
1.1 APT_BUFFER_FREE_RUN 2.1 DS_OPERATOR_BUILDOP_DIR
1.2 APT_BUFFER_MAXIMUM_MEMORY 2.2 OSH_BUILDOP_CODE
1.3 APT_BUFFER_MAXIMUM_TIMEOUT 2.3 OSH_BUILDOP_HEADER
1.4 APT_BUFFER_DISK_WRITE_INCREMENT 2.4 OSH_BUILDOP_OBJECT
1.5 APT_BUFFERING_POLICY 2.5 OSH_BUILDOP_XLC_BIN
1.6 APT_SHARED_MEMORY_BUFFERS 2.6 OSH_CBUILDOP_XLC_BIN

Wednesday, December 12, 2012

Encrypting Data using "tar" and "openssl" in Nix



The following shows an example of writing the contents of "tapetest" to tape:

        $ tar zcvf – tapetest | openssl des3 -salt  -k secretpassword | dd of=/dev/st0

     Reading the data back:

Tuesday, December 11, 2012

InfoSphere DataStage Jobstatus returned Codes from dsjob



Equ DSJS.RUNNING To 0
 This is the only status that means the job is actually running
Equ DSJS.RUNOK To 1
 Job finished a normal run with no warnings
Equ DSJS.RUNWARN To 2
 Job finished a normal run with warnings


Monday, December 10, 2012

DataSet in DataStage


Inside a InfoSphere DataStage parallel job, data is moved around in data sets. These carry meta data with them, both column definitions and information about the configuration that was in effect when the data set was created. If for example, you have a stage which limits execution to a subset of available nodes, and the data set was created by a stage using all nodes, InfoSphere DataStage can detect that the data will need repartitioning.

Friday, December 07, 2012

A Discussion Group for you

Hi There
I've created some groups, be a part of It and discussion .....

LinkedIn
Google+
IBM DeveloperWorks
FaceBook




till then.....
njoy the simplicity.......

Thursday, December 06, 2012

Make a File "immutable" or "unalterable" in Nix


It cannot be changed or deleted even by root. Note this works on (ext2/ext3) filesystems.
And, yes, root can delete after it's changed back.

     As root:

       $ chattr +i filename

Tuesday, December 04, 2012

Alphabetical list of stages in DataStage



The following tables contain an alphabetized list of all the stages that are available in IBM InfoSphere Information Server, Version 8.5, as included with the base installation or with add-on installations.

Whether a particular stage is displayed on the DataStage Designer client palette depends on the type of job you are creating and the products and add-ons that you installed. On the palette, stages are organized by category. In this document, stages are organized alphabetically.

Sequence job stages


The following stages are available when you create a sequence job.



Stages that are available in sequence jobs

 

Parallel job stages and server job stages [ A - F ]

 The stages in this document are included and available with IBM InfoSphere DataStage unless otherwise noted in the following key.

Palette category Description
Data Quality1 Available only with IBM InfoSphere QualityStage
Data Quality2 Available as a separately licensed add-on module to InfoSphere QualityStage
Application Available as an add-on Pack to IBM InfoSphere DataStage and QualityStage

The following key includes additional notes about stages in the Designer client.

Stages in parallel jobs or server jobs [ G - P ]

The stages in this document are included and available with IBM InfoSphere DataStage unless otherwise noted in the following key.

Palette category Description
Data Quality1 Available only with IBM InfoSphere QualityStage
Data Quality2 Available as a separately licensed add-on module to InfoSphere QualityStage
Application Available as an add-on Pack to IBM InfoSphere DataStage and QualityStage

The following key includes additional notes about stages in the Designer client.

Stages in parallel jobs or server jobs [ Q - Z ]

The stages in this document are included and available with IBM InfoSphere DataStage unless otherwise noted in the following key.

Palette category Description
Data Quality1 Available only with IBM InfoSphere QualityStage
Data Quality2 Available as a separately licensed add-on module to InfoSphere QualityStage
Application Available as an add-on Pack to IBM InfoSphere DataStage and QualityStage

The following key includes additional notes about stages in the Designer client.

Saturday, December 01, 2012

star schema

 
In the star schema design, a single object (the fact table) sits in the middle and is radially connected to other surrounding objects (dimension lookup tables) like a star. Each dimension is represented as a single table. The primary key in each dimension table is related to a forieng key in the fact table.