DSXchange

Hi All, I have a Flag in my Job based on which I have to either Insert a record or Update the record in the target. While Update i have to update only 3 columns out of 10 thats the reason i cannot use "Insert/Update Option" in a single link. I searched the forum for such cases and found th...

The "order by" won't affect the actual lookup itself but can affect the hashed file population. Where exactly do you "order by"? And "rejected" in this case means the looku ... I am doing the 'Order By' while selecting the records through the Oracle Stage i.e. just bef...

Sorry Craig, I didn't get your point and what your were pointing towards. I will just explain my Job design. I have some records from the Source tables. I have a Lookup query which brings the Policy Numbers and other requred feilds with it in a Hashed file on which a Lookup is done. Now I need to ch...

But When I use my query as is and do Lookup on it .... I miss out some records which are actually present in the LookUp and which should have matched..............And when I order by my Lookup query and take data in the Hashed file all records wihich actually should match goes in the target.......Wh...

Hi All,

I have a simple question, Do we need to provide a sorted data as input to a Hashed Stage so that a proper and correct lookup logic can be applied on the hashed file????

Thanks in Advance.

I am doing a UtilityHashLookup on a hash file to read a value from the hash file. I have written this transform utility in the "Expression Editor" of the "UserVariables_Activity" stage. For e.g. UtilityHashLookup("testparam", 1, 1) in the "UserVariables_Activity&qu...

Hi All, I have a date in the format 'YYYYMMDD'. It will be the last day of a month for eg. 20080831 now I need to derive two dates from this date one is Start date of next month i.e. "20080901" and End Date "20080930". I searched in the forum and found out the solution for parall...

Thanks Craig it working now. I used as follows:

OCONV(ICONV(ColumnName,"D DMY"),"D YMD[4,2,2]")

My date format is "19-SEP-08" in source table.

Hi All, I am getting a strange issue with Iconv Oconv function. I have generated a function to retrive a date and insert it in the target table. The function i have written is as follows : " OCONV(ICONV("Column_Name","D-MDY"),"D YMD[4,2,2]") " It is working fi...

Actually, i kept them as it is initially and did the "View Data" but then i got the error saying "Attempt to convert string value '01-SEP-01' to Timestamp type unsuccessful". But i checked the source datatype in table table and it is actually a date format. Still i then changed t...

Thanks Craig and Ray for your valuable pointers.
I could get the link Information through dsjob in the Unix Shell script.

Hi All, i have a source table having some date fields. i am extracting the data for these columsn in the 'Oracle OCI 9' Stage. But when I import the metadata for the same table through DataStage; the Datatype is coming as "TimeStamp 38". Why is DS importing the column datatype as "Tim...

Hi All, I want to execute the commands "DSGetJobInfo", "DSGetLinkInfo" through Unix shell script to get information like "StartTime" "EndTime" and records passed throuh the links of a particular job. I further want to get the output of these functions in a var...

Thanks for your Inputs.....Actually I am executing a Stored Procedure through DS Job .....the stored procedure is returining values in a "table type" format....just wanted to know if the STP can take this records set and proceed ahead with the transformation.....I will check in pdf and try...