Category: DATASTAGE TUTORIAL
Error: The input schema column name is not used and the connector is configured to stop when unused columns are detected in the input schema. Explanation: The specified input …
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 …
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 …
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 …
IBM DataStage Flow Designer is a web-based UI for DataStage, compared to DataStage Designer, which is a Windows-based desktop client. We can use IBM DataStage Flow Designer to create, …