Monday, August 18, 2014
Saturday, August 09, 2014
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
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:
Thursday, August 07, 2014
Python is powerful... and fast;
plays well with others;
is friendly & easy to learn;
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 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
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.
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.