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

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.

Monday, August 04, 2014

Oracle SQL Tuning Tips - 3



  • Oracle automatically performs simple column type conversions(or casting) when it compares columns of different types. Depending on the type of conversion, indexes may not be used. Make sure you declare your program variables as the same type as your Oracle columns, if the type is supported in the programming language you are using.Use:
    SELECT emp_no, emp_name, sal FROM emp WHERE emp_no = ’123′;
    HERE if emp_no indexed numeric, then after implicit conversion query will be:
    SELECT emp_no, emp_name, sal FROM emp WHERE emp_no = TO_NUMBER(’123′);
    Thus, index is used in this case.
    Don’t use:
    SELECT emp_no, emp_name, sal FROM emp WHERE emp_type = 123;
    HERE if emp_type is indexed varchar2, then after implicit conversion query will be:

    SELECT emp_no, emp_name, sal FROM emp WHERE TO_NUMBER(emp_type) = 123;
    Thus, index will not be used in this case.