DSXchange

Hi All, Could any one please tell me about datastage product upgrade informations. like when was datastage 4.0 introduced after that what are all the next verisons released on what dates...?? just want to know the datastage etl tool history...let me know if you could provide this information. Mahi_m...

What routine is being called by the Routine activity, and with what argument values? UtilityHashLookup is being called in the routine activity stage which is used to pass a value from the hashed file to the server job. arg1--hashed file name with fullpath arg2--Hashed Key value(which i am not able ...

I have a sequence job where I gave the routine activity stage followed by the server jobs where in we call the arguement. When I checked the log for Sequence job, Step1: Routine_Activity stage started Step2: Routine_Activity stage: *TABLE NOT FOUND* The hashed file is being declared in the account. ...

Hi, thanks a lot for the quick response. I loaded data to a hashed file as suggested by DSGuru. But when I was passing the arguements to the UtilityHashLookup, I could not understand by Hash Key value which is the second arguement for hash Utility lookup routine activity. Please explain me. I gave ...

Hi, thanks a lot for the quick response. I loaded data to a hashed file as suggested by DSGuru. But when I was passing the arguements to the UtilityHashLookup, I could not understand by Hash Key value which is the second arguement for hash Utility lookup routine activity. Please explain me. I gave t...

Can u pls be clear. sorry I could not follow.

I have to take oen value from xls at a time and run both the jobs in sequence because the first job is creating a hashed file which is used in the second.

We use the value taken from the file as parameter in both the jobs

Hi I have 2 jobs which take a vaue from one of the columns of an excel sheet. Job1 has to be run first and then job2 for each value of the parameter taken from the xls.(or .csv) there are 2300 rows in the csv file. I tried runnign job 2 for one value and it ran for 3min. Please let me know how can I...

Hi I have a stored procedure which takes two arguments (agr1, Arg2) and updates ColumnY with Agr1 in 10 tables where column X=arg2. But both the input values are looked up in 2 diffrent tables(one lookup with 130 rows and the other with (832250) and then passed to the Stored Procedure. There are tot...

In this case use date set that only has one key defined and use that as a hashed file and use the other dataset with two keys defined as the driver. By reading through your other posts i believe you have a choice in which data set can to use for lookup. Hence, this is the only other way i see. But ...

Is it that both the key columns are not considered as a composit key? Are they considered keys seperately? For value in Column C1 there are duplicate values coming in for C3. I need to have all the values of C3 in the hashed file. I mean the combination is unique. In that case how should I proceed? ...

Can somebody please help me out in this regard.
My question is if there are 2 key columns in a hashed file, do we need to have join condition for both of them.

The situation is i have 2 keys. but I have only one column to compare.

Thanks a lot for the quick response. I have DatasetA(C1, C2, C3) and very less number of rows than DatasetB(C2, C3) So I hope A has to be used as a lookup as per my understanding. Correct me if I am wrong. I have C1, C2 C3 columns in Set A and C2, C3 in set B. I have to compare C3 from both the data...

Hi all, My requirement is as follows. There is a query Q1(say) with some set of tables which has 2 filter conditions. another query Q2 on the same set of tables with one filter condition.(this filter creteria is same in both the queries) I have to compare both the query result sets. I feel the query...

Hi All, My requirement is like below I have a input file which is having 10 records in trnaformer iam calling a basic routine where am doing some process and returning a value to output. my question i need to declare a variable in routine and this should incremented every time when i call the subrou...

Hi All, I would like use array concept in basic routine for my requirement. in basic routine i need to open a file and read record by record and based on condition i need to build an array i tried with using metaread but i could not scucceed please let me know the correct command to use to build an ...