DSXchange

ivannavi wrote:Hey, I didn't know output of the command was available in Execute Command Stage! Only return code for the trigger.
Where can I find output?

For Execute Command activity there is an activity variable "$CommandOutput" that stores the output of the command.

Thank you Chulett.

Hi All, any suggestions on this issue.

Your help would greatly appreciated.

Regards,
-Sumit

Done : DSD.RUN indicates a run of a server job. Now why this is appending to your Execute Command Stage can be figured out only by knowing what exactly your are doing with Execute Command Stage. Thank you for your reply In the Execute Command Stage I am running the following code: grep 'TRAILER' #$...

Hi, I have a sequencer job that has three stages that are called in series Stage 1: Job Activity Stage - It calls a multiple instance job (Job1) Stage 2: Execute Command Stage - It executes a unix command. Stage 3: Job Activity Stage - It calls another job (Job2) based on the output of unix command ...

We dont have update access to the database with the username we provide in the mappings to connect to the target database. Please let me know why we need an update access to the target database in normal scinario? If you need to update any row on any table you need an update access on that table. F...

Thank you all for your inputs.

Regards,
-Sumit

Thanks Ray and Arnd, Splitting the key column logically is not possible. So, if we create say 5 files there is no way we can ensure that the data would be evenly distributed across these 5 files. Certainly creating only 1 hash file would be a bad option because the size of that file would be around ...

Hi, As per a business requirement we need to make a lookup to a table based on one key column. The lookup table has 25 million records and a direct table lookup would kill the job performance. Hash file probably is a good idea but we do not want to create the hash file because of two reasons: 1) We ...

1)Now how do I use the UtilityHashLookUp(HashName,'Value',1) in the seq In the hash file define two colums DummyKey and Date. In Job 1 hardcode the value of Dummy Key to 1 and pass your date value to column Date. In the sequencer Call UtilityHashLookUp using RoutineActivity Stage. It asks for three...

Hi, I have a requirement, where my First job gives me a time stamp. Now I need to pass this on to the Second job , where it wuill be used in the ORA stage Query . How do we go about this, thanks :roll: Hi Vinay, Two ways to do it: 1) Store the date in a hash file in first job. Read the hash in the ...

chulett wrote:There are specific syntax examples in the post I linked to above.

Thank Chulett. This is so simple. What we have done in our project is very complicated compared to this.

Thanks again.
-Sumit

pnchowdary wrote:Hi Sumit,

I believe that Remove Duplicate Stage is present only in the PX version (EE version) but not in the server edition. Guys, please correct me if I am wrong.

Thanks,
Naveen

Thanks Naveen.

Thanks for the help Hi tjmalone, did it work for you. If yes could you please send me the exact that you used. Actually we were facing a similar issue in our project but we didn't know using EReplace or Convert how do we first read a CR or LF value. So, what we did was we used Iconv Oconv to conver...

can use any of the follow 1) can use a transformer/filter to check all the colum for null 2) can use aggregator to group by any unique column and filter out the blank row 3) If every other rows are unique, can use Remove Duplicate Stage Kumar, just curious to know if we have any Remove Duplicate St...