DSXchange

Kim, May your heart and soul find peace and comfort

You need to change your logic slightly.

Use the below one.

sCurrentValue : If NullToValue(Input column,"")<> "" Then InputColumn Else sPreviousValue

sPreviousValue: InputColumn

The problem has been resolved. Thank you.

Hello, Is it possible to replace OCI with DRS Stage? If So, try once.

Thanks for the correction chulett.

Oh ok. Thank you.

Yes, I have done the same as Chulett metioned for one of my requirement. It's a workaround solution.

Ray/Chulett

Thank you so much for sharing this information.

Thank you Ray.

Dear Talent Pool, What would be the maximum data volume size Information Analyzer support? I know this question looks silly; but, in my Organization some of the DataStage supporting groups complaining about the Information Analyzer performance. Can anyone tell me what would be the Ideal data volume ...

Both the tables DS_JOBS and DS_OBJECTES contain underlying metadata information about all the DataStage Jobs in a project. Like. JobId, Name, Created By, Modified By...etc. Thank You.

Murthy,
You will find in the project installation directory. But, you can't read directly those UV tables directly. You have to fire proper SQL queries in the command prompt (Administrator) for a respective project. Thank you.

Code is in production. Just want to understand whether this special character is causing the NULL value ? Can you please share your thoughts? Thank you.

I can't copy that symbol. But it is Concatenated with 2 vertical boxes.

There is an option available in Sequential File Stage called Filter. This option directly deals with Operating System where your DataStage server is Installed either Unix Flavour or Windows. Write respective script(either dos/Unix based on your Operating system) in the Filter option and ristrict dup...