DSXchange

Hi, I have a Notes sql data source. It has a column with Timestamps stored in it some of which are Nulls, Whenever datastage reads a null in select statement against data type Timestamp it gives an error and job fails. I tried to convert the source into a varchar instead but job still fails on the f...

Hi, I have a Table which contains data in this format: ID CITIES 12 Lahore,Karachi,Islamabad 23 Dubai, Abu Dhabi 45 New York 46 London I need to separate this data like this: ID CITIES 12 Lahore 12 Karachi 12 Islamabad 23 Dubai 23 Abu Dhabi 45 New York 46 London Please suggest some ways in Data stage