DSXchange

I have a simple job with a Teradata connector as the input and a sequential file as the output. The Teradata connector uses a parameter driven SQL statement to pull all the specified fields from a single table. RCP is enabled on this job due to the dynamic nature of the query. There was a new field ...

Thanks Craig!!! I completely forgot about the field marks. That did the trick.

I have a simple job that creates an extract. I want to compare the current extract to the previous extract to see if there are any differences. If there are differences then I want to send an email to notify a group that there are differences. If there are no differences then I don't want to do anyt...

Thanks for that suggestion. I'm guessing that would work but I'm not sure if we can modify the data in any way. I have a feeling that will be considered a no-no. I'll give it a shot though.

I'm at a loss trying to find a solution for my problem. Below is a simple illustration of my job. There are multiple Column Imports/Transformers/Data Sets coming off the first transformer but I only showed the direct path for a single one. This job reads messages from the MQ and routes them to their...

Thanks for the possible solution. I tried this but couldn't get it to work correctly. I still couldn't get it to display a 0. I ended up going in a completely different direction and was able to get it to work. The new approach was this: cut -f 2 -d ':' file_rec_ct1.txt | gawk '{printf("%'"...

Below is what I have in my User Variable Activity. File1_Rec_Ct: "`cut -f 2 -d ':' file_rec_ct1.txt | sed 's/^0*//'`" File2_Rec_Ct: "`cut -f 2 -d ':' file_rec_ct2.txt | sed 's/^0*//'`" File3_Rec_Ct: "`cut -f 2 -d ':' file_rec_ct3.txt | sed 's/^0*//'`" and so on....for a...

Would I need to do this comparison in another user variable activity? I don't believe you can reference another user variable within the same user variable activity. I've tried the below syntax in the user variable stage but it would never display a 0 when the record count was 0. If "`cut -f 2 ...

I have a user variables activity in a job sequence. I have defined 12 user variables within it and one example is below. Each variable pulls the record count from a different text file. The text files each contain one line with the record count from an extract. The sample text looks like this: --Row...

My solution for this is below. It was a fairly basic solution in the end. The job is scheduled to run at 12:01 AM everyday. I created a environment variable (default is 0) in case there are issues with the run and it's delayed more than a day. This was the main reason we're going away from the UNIX ...

You can disregard this. I believe I've figured out a way to do this.

Craig, Maybe you can help me with doing this a different way. I have an existing job sequencer that has an Execute Command Activity that pulls a start and end date from a UNIX file. It then uses those two dates to create two variables in a User Variable Activity (Start Date and End Date). Those two ...

Here's the link: http://www.databaseetl.com/user-variabl ... datastage/

I came across a webpage where somebody showed how you could use the ExecuteSQL function within a user variable activity in a job sequence to create a variable. There was very little explanation of how exactly to do this on the webpage though. Has anybody done this before and if so, do you know of an...