DSXchange

If any of you have worked with Datastage using Terminal Server connectivity, could you please share your thoughts? If you have any document on this, pls send it across. We are looking at something which gives pros and cons if we access Datastage using Terminal Server like Client side installations?,...

Hi,

In the transformer, we can always use the substring function to incorporate 'like' functionality.

The other way could be using case statement in sql query and using an indicator field if it satisfies the like condition. and using it in the transformer.

Thanks everyone,

I guess this should work. will get back if it doesn't

Hi Yamini, Thanks for the reply. But When we include the sequential file in a job, we get the records rejected. But that's not i want. I want to capture the number of rows rejected. i.e the sequential file should display information like a. Number of Rows Rejected - Count of rows rejected. something...

The information which i need to capture is the number of rows rejected and the reason for rows rejected. Please let me know how can this be done