COLLECT STATISTICS IN TERADATA

COLLECT STATISTICS IN TERADATA: This post will help you to understand collect stats importance in teradata database.DK®

Read multiple files using sequential file stage

How to read multiple files using single DataStage job? DK®

This article provides different ways of reading multiple files (having same or different metadata) using a single job.DK®

Datastage Scenario Based Question/Answer : 6 - Transformer Looping

Transformer Looping Functions for Pivoting the data :

Convert a single row into multiple rows using Transformer Looping Function? (Pivoting of data using parallel transformer in Datastage 8.5 or newer versions)

Datastage Scenario Based Question/Answer : 5

Datastage Scenario Based Question/Answer :5DK®

Create datastage job with below mentioned scenario based on below given input data.DK®

Configuration does not contain the invoking node

Configuration does not contain the invoking node error :DK®

This post will help you to resolve the error "the configuration does not contain the invoking node" in DataStage.

Start Stop Websphere services without password

Start Stop Websphere services without password:DK®

This post will help you to start/stop websphere services without  password on any linux/unix datastage server.

Login to Websphere without wasadmin password

Login to Websphere admin console without password:DK®

Transformer STRING FUNCTIONS in Datastage

Transformer STRING FUNCTIONS in Datastage: DK®

DS11.3 Client Certificate Warning Popup Fix

DS11.3 Client Certificate Warning Popup Issue Fix:DK®

Convert Special Characters to Any Other Char

Convert Special Characters to Any Other Char:DK®

Untranslatable Character Data Handling in Datastage

Untranslatable Character Data Handling in Datastage

"Failed. 6706: The string contains an untranslatable characters"DK®

Datastage Jobs showing a status of "Queued"

Datastage Jobs showing a status of "Queued":DK®

Datastage Expired user id Log in into DS but not in Unix

Datastage Expired user id be able to log in to the DataStage server but not to the UNIX system :

SQL5005C The operation failed : DB2 Error

"SQL5005C The operation failed because the database manager failed to access either the database manager configuration file or the database configuration file." At windows machine system startup error DK®

No engine credentials were found Error Solution

No engine credentials were found on the services tier on information server engine/ Failed to connect to information server engine user name password incorrect : issue while login into datastage clients

Datastage C/C++ Compiler issue on Windows Machine

Datastage C/C++ Compiler/Transformer Jobs Not Compiling: DK®

This post will help you to solve your Compilations Error when compiling a transformer based jobs (solution for Windows server machine). DK®

IBM DataStage Job Status Codes

IBM DataStage Job Status Codes 

This post will help you to understand dataStage job status log  values seen during execution, running, completion or failure of job. DK® 

IBM Datastage 11.3.x Newly Added Features

IBM Datastage 11.3.x  Newly Added Features :

Please go through this post to understand newly added features/stages in newly introduced IBM Datastage 11.3.x version. This post contains datastage part only .Apart from that, There are so many changes happened in information server suite level. I will try to add those in my next posts.