DSXchange

I am using URL path as below to read a CSV file from a remote location. Its throwing an error saying Error occurred during initializeFromArgs(). <FTP_Enterprise_11> uri is having invalid syntax. Please help me to resolve this. ftp:\\usawuxc02\BA_Shared\INTRANET\UNIT TRACE\GAP DOWNLOADS\SIT-LITE.csv

Hi folks, I have the following data. I can imagine doing this in loop but would take lot of time as there are many records. Is there any quick way of doing this in datastage? I know this can be acheived using shell. As i am poor in shell I want to see if this can be done in DS. Any help is greatly a...

If (Column_1)='0004400' And (column_2)='1221' And Index(column_3,"NOG",1) <>'0' Then 1 Else 0 Output: column1 column2 column3 0004400 1221 DONOG 0004400 1221 NOG-NEW Eliminate all other cases Hi I have a requirement where i need to reject null values and empty spaces as well for all the t...

I am stuck at this case finally: id bid_no 200 AC634 200 AC455 I need to extract above two records from the remaining records,which are different from other cases. The rule is : if ids are equal , i need to check if their bid_nos start With AC but numerical is not equal . In this case 634<>455. Can ...

Thanks Naveen and Ray.. The actual requirement has been changed and is as below. Input id name bid_no bname inum custname 100 *sam AC100 sam 64546 Assoc 200 tom AC345 tom 45645 Build 200 tom AC345 tom 45666 Build 200 tom AC345 tom null Build 500 jam AC888 jam 98080 facet 300 can BC399 ban 52344 coun...

Thanks Sura . your understanding is right as per my requirement. As you said it looked so simple to me. I can first check the condition to see if role = duty and then remove duplicates based on id in the downstream. If role is not matching with duty i need to reject them. These are my assumptions as...

@Jwiles, I am lost with the requirement .Also, I am trying to run a query against the db but its taking forever . I need to split this query and design a DS job . I just got some sample data with me. Let me get the actual data from the query first , analyse it and will post the complete requirement ...

Input Id Role Duty 100 *Athlete Athlete 100 *Athlete Running 100 *Athlete Swimming 200 *Manager Accounting 200 *Manager Manager 300 Clerk Supervision 300 Clerk Clerk Output Id Role Duty 100 *Athlete Athlete 200 *Manager Manager 300 Clerk Clerk Sorry I understood your explanation but i dont know how...

Thanks Jwiles.

Since we are using 8.1 here, I couldnt imagine how rows-per-id can solve this....Can you please elaborate on this?

I do need suggestions to solve this uncommon requirement: Id Role Duty 100 *Athlete Athlete 100 *Athlete Running 100 *Athlete Swimming If the Ids are equal then i should check for the columns role and duty : The rule is if ids are equal then output only the row whose role and duty are equal after tr...

I just meant you can't let the derivation resolve itself, you need to wrap it in an if-then-else and say "if BLAH_BLAH_BLAH then @TRUE else @FALSE". Do that in a well-named stage variable and now you can just put that stage variable all by itself in the constraint. As an example, name the...

Sorry My fault. Will keep this in mind next time.

chulett wrote:Again, what comes from the OConv is nothing that can be treated as a boolean. You'll need to explicitly check the output and then (if so desired) set the result to true/false.

I am new to this Oconv thing and never used stage variables.
Can you please explain in detail? Sorry if you get annoyed.

Pay closer attention to what Ray noted was the result of the OConv. NOT((Oconv(DSLink.code, "R700,709;800,849;860,867;870,876;880,899") And Oconv(DSLink2.num, "R700,709;800,849;860,867;870,876;880,899") And Oconv(DSLink2.typ, "R700,709;800,849;860,867;870,876;880,899")...

It was vague , so i had to repost.