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.......

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.

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.

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

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....

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

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.

DataStage Naming Conventions

DataStage Naming Conventions follows the guidelines of ETL Naming Conventions.

Contents 1 Job Name Prefixes 2 Stage Names 3 Link Names

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

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:

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

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.

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.......

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

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.

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.