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 …
You have been working on DataStage and most of the times you have used Lookup stage for lookup data from reference link. Suddenly you heard about Sparse lookup and …
CurrentTimestamp(),CurrentDate() and CurrentTime() functions are most useful functions in DataStage when we are dealing with the jobs to get the ‘current’ date and time stamp. Generally we use these …
This is continuation for previous post. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.TRUEFALSE Which of the …
