DSXchange

I actually dont know the value of the due date before the start of the job. It is a column in the file I first load into the job and it remains the same in all the rows. INPUT FILE: date,data 03042004,123 03042004,143 03042004,2341 ......... and so on. Now I do some processing on the data and output...

Actually at the end of the transformer stage the value in the stage variable is set with a fixed value. Also, yes the date wont change due to certain conditions implemented. Essentially, at the end of the transformer run, the stage variable will have a single value set in it. Now apart from writing ...

Hi Everyone, I am having a problem with using a stage variable in a transformer when writing a sequential file output. Heres the problem: I have a stage variable "duedate" whose value is 05062004. When I write the transformer data to a sequential file, I want the sequential file name to be...

Can we do a lookup with an ODBC stage?? what could be the difference of doing it with hash stage and a ODBC stage. Do I get any performance issues if I do a lookup with ODBC stage??

thanks

Hi! All

How to concatinate the data of the same column. I tried using stage variables and even tried using hash file but I don't know what I am doing wrong. Hope I will get helped.

For example

Input data
1
2
3
4
5
6

Result should be

12
34
56
thanks,
RR

Can we write a shell script to add new parameter in the dsx file for example the script should add these lines in the dsx files. BEGIN DSSUBRECORD Name "TDServer" Prompt "Server Name" Default "TD" ParamType "0" END DSSUBRECORD and it should also search for tha...

Hi,

How can we add a new parameter in job properties for all the existing jobs in a project?

For example, how to parameterize the Max Record Number in ORAOCIBL stage which is default to 100 in all the jobs. Can we write any shell script??? If yes, hope I will be helped in writing.

Thanks,
NR

Hi, In plugin stages like FastLoad, MultiLoad, Terabulk etc we are using the sessions max and min as 0 all these days. We are thinking to Parameterize the session max and min for all those stages. Does anyone have experience using session min/max with Teradata and how effective are these parameters ...

I have around 10 columns in a Sorted table, in which two columns are unique indexes and what I want to do is I want to compare the data of both the columns with previos rows to eliminate duplicates. Like both columns data shouldn't be equal in two rows. I tried using the stage variables looking at R...

Ray, As I mentioned our source from the database is ordered by id and date and the date field is going to the reject file in the transformer.When we tried to add "1" "ascending" on the id field in the aggregator input stage and group by on the id in the output field, it aborted w...

DataStage Version 5.2