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

Thursday, August 07, 2014

Python Tutorial for Beginners

Python is powerful... and fast;
plays well with others;
runs everywhere;
is friendly & easy to learn;
is Open.


Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C. The language provides constructs intended to enable clear programs on both a small and large scale.