DSXchange

IT WORKED !!!!


@qt_ky : Thank you very much. Appreciate ..

Warm Regards,
Kumarjit.

Hi. I am trying to do a SPARSE lookup from a reference table(SQL Server, accessed by ODBC Connector stage) and the actual lookup logic is given below: SELECT COUNT(1) AS TESTCNT FROM TEST WHERE SUBSTRING(TEST_ID,1,6)=orchestrate.SRC_CD The column SRC_CD is coming from the stream link and the record ...

@Craig: The answer for "Why" would be a decision by the client and my company, I am only a way to implement it. As far as providing a sample logic goes, I cannot paste the actual server routine code here in this forum, hence I quoted it as a "logic" of the code piece rather than ...

Hi there. I am undertaking a project assignment to convert a set of Server Routines into parallel ones, but I have never worked on routines before, and I am totally unaware of the server routine constructs. The logic of one of the server routines that I need to replicate is given below. This routine...

Team. Please help me understand this issue(which might look easy). I am performing checks on three input columns coming from A fixed width source file to validate whether any of these columns Has whitespaces. For that I use the following if else in a transformer Stage variable. If Len(trim(col1))=0 ...

Yes, anbu's solution worked, though the requirement was indeed ridiculous.

Regards,
Kumarjit.

@Ray: As Craig has mentioned, the output would be a sorted column(col2), values of which will be continuous and range from min(col1) to max(col1). @Craig: Looping does work good in this case where the input is already sorted in ascending order , but what if the input column values are staggered(like...

Hi. I have a source file with a single input column in it. A sample input might look like: Col1 1 8 4 5 7 3 10 My requirement is to get a single column output(say Col2), with record values ranging between min(col1) and max(col1), and in a ascending order Col2 1 2 3 4 5 6 7 8 9 10 One approach that I...

@chulett: Thanks a ton for the If Else construct Craig, and everyone else who had chipped in their thoughts.

Yes. That If Else block suffices.


Warm Regards,
Kumarjit.

You are absolutety rite Craig.
But there are 15 columns that I need to check and get the First non empty value.
And, I am not able to construct the If Then Else block.

Could you please help on that?


Thanks.
Kumarjit.

Earnest thanks for all the help. I think that I can get over this, provided that I'm abble to address the issue below. This is the lone step that's standing between me and success, and I seek all your help on it. A sample input is: account_00 account_01 account_02 1001 1001 1002 1003 1003 1003 The o...

Thanks Craig.
Will try implementing a Fork Join design, and post on the result.


Regards,
Kumarjit.

@info_ds: Thanks for the suggestion, but the input data is fully file based; we even do not have access to any database from our Datastage jobs.


Any other help is appreciated.


Regards,
Kumarjit.

Hi. My input is as follows: account# currency category fee amount 1001 USD Investment_Retail 100 1001 CAD Equity 200 1001 CHY Group_Liquidation 300 1002 USD Investment_Retail 400 1002 CHY Group_Liquidation 500 The output expected is: account# currency Investment_Retail Equity Group_Liquidation 1001 ...

Thanks for the suggestion Ray, but if that was a problem at the script level, the script would have never run at the first place.

But as I said, the script works perfectly standalone, or when run with Specific Program(s) option set in the stage.


Regards,
Kumarjit.