Tuesday, September 02, 2014

Peek Stage in DataStage - 1


The Peek stage is a Development/Debug stage. It can have a single input link and any number of output links.
The Peek stage lets you print record column values either to the job log or to a separate output link as the stage copies records from its input data set to one or more output data sets.


1. Design :

We are using below design to demonstrate the functionality of PEEK stage in datastage. Job design is having 3 stages, Row Generator , data source, for generating the dummy data for the job. Here, we can use any data source whether it is DB, dataset or flat files. Transformer, just as a stage, creating negative values of source data. Peek for Peeking :-) 

Monday, August 18, 2014

Oracle table is Partitioned or Not ?


For getting whether Oracle table is Partitioned or not, we can use below query on ALL_TABLES -


Saturday, August 09, 2014

DataStage Scenario - Design10 - job1


DataStage Scenario Problem -->  DataStage Scenario - Problem10 

Solution Design :

a) Job Design :  


   Below is the design which can achieve the output as we needed. In this design, we are reading the data from flat file, generating a dummy column in column generator stage, doing aggregate on that and sending the output to seq file.




Friday, August 08, 2014

WAS server location for IBM Information Server


How to find Correct WAS server using by your Information Server ?


IBM Information Server uses a Websphere Application Server. If you have multiple WAS servers installed, to find the one that IIS is using you can look in:


C:\IBM\InformationServer\ASBServer\bin\setupEnv.bat
or
/opt/IBM/InformationServer/ASBServer/bin/setupEnv.sh