In this post, you will learn about the Oracle DUAL table which is a special table used for evaluating expressions or calling functions. Now let’s dig into more on …
In short, the difference between UNION operator and UNION ALL (UNION vs UNION ALL) operator is UNION gives unique results set in the output even though the combined result …
CC_MSG_LEVEL is a environment variable in DataStage and you can set this at job level and mostly it will be helpful to debug the issue that you are facing …
Audit events are recorded in the audit log file on the DataStage Server Services tier. Logging in to or out of any InfoSphere Information Server client application or command-line …
ALL_TAB_COLUMNS and ALL_TAB_COLS are the views in Oracle that describes the columns of the tables, views, and clusters accessible to the current user. The only difference between two views …
Problem: I have one file and it contains city names and distance between them. But there are duplicates, we need to remove those duplicates by using stage variables in …
DENSE_RANK calculates the rank of a value in a group of values. The return type is NUMBER. If two or more rows tie for a rank, each tied rows …
As a developer you always define the columns and their datatypes in ‘Column’ tab in each stage. Schemas are an alternative way to specify column definitions for the data …
