DSXchange

Close designer and relogin to the same project and verify.

Just copy the DSParams file.

Will there be any issue while comparing the empty value of svPrev with svCurr for the very first value? No. Or will there be any garbage value (if not then what value is defaulted in svPrev?) assigned to svPrev? Stage variable default value will be the default value of the stage varaible datatype. ...

You need to add these system variables to DSParams file. Or Copy DSParams file from other DS Project and place it under your project directory.

If you are confident that rest of length are spaces you can demote this warning into an info using message handler.

But still, i would rather prefer transforming the source to have length of 26 before lookup. In this case message handler is not required.

When you code @DATE in your derivation does your job compile?

How can you expect a string whose length is 40 to compare correctly with string length of 26?

Why don't you increase the length of lookup column to 40?

Examine the generated OSH. OSH can be viewed through "Generated OSH" tab in your job properties window.

If you do not get this tab in your job properties window then enable it using administrator.

I would have used transformer.

I had asked you to use column generator and not row generator.

It seems Ceil() exists only in help.

Try this.

Use Function Ceil.

Use Column Generator stage to generate a new column with values of 0. In the downstream copy stage drop the old column and rename new column name to old column name.

Set $APT_DISABLE_COMBINATION to true to find the source of this error.

veera24 wrote:

balajisr wrote:Thanks Craig for your useful alert.

As i don't have the membership i couldn't see chulett's comment. So could you pls. help me out to get to know.

Thanks in advance,
Veera

I am sorry.It is not fair to post premium content.

Why don't you buy premium membership. Certainly worth it.