DSXchange

Hi,
What is the datatype of the return port you are using?

Hi Sultan,
You will have the NULL handling property in the source stage where you can set the default date (may be '19000101') and then try executing your job.

Hi,
You can EDIT the column which you are generating in Column Generator and there is a tab to specify the Default Value. You can specify whatever default value you want out there.

your junk data itself is very wierd.... ususally junk characters like {},#,....etc. appear which needs to be cleansed... and for that we usually go for the way i suggested earlier.... identify the ASCII value and remove them by adding a constraint.... this will help you solve your problem with less ...

Hi, Please go ahead and make use of join and lookup stages (lookup - for low volume). The whole idea of getting an ETL engine into the picture is to avoid the overhead on DB. So you can very well go ahead and make use of the available DataStage stages and code it as per your requirement instead of h...

To identify junk values you can still make use of the existing transformer stage and filter out the junk values there itself. Just identify the ASCII values for the junk values you are getting in the file and have them filtered in the transformer stage. if it is only 1 or 2 values you can directly u...

This has got nothing to do with your Teradata Partitioning. If you are using Teradata Enterprise Stage then you should concentrate on the partitioning that is happening at DataStage end and not at Teradata end. Please revisit your DataStage code with respect to partitioning and let us know.

How can you write an SQL Query on a DataSet in the first place? You either need to load the DataSet into a tabel and then try out whatever query you were planning to implement.

You can use DataSet Management in the TOOLS to achieve this. But the exact functionality for which you are doing this is not going to get resolved. In DataStage you cannot rename a DataSet. You can only copy it and reuse it using the Orchadmin cmd.

Jayakannan,

The first tab (COMMAND) is for specifying your shell alone (ksh...)
In the second tab (PARAMETERS) you need to specify your script name with the parameter values passed to it.

Hi, In the Execute Command Stage, there will be two tabs. In the TOP one defined your shell (ksh,...) and the bottom mention your script whatever you are trying to call (xyz.sh,...)... Is this the way you are calling your script in your Execute Command Stage... ??? If this is not the way you are cal...

Hi Raju, The Error Log clearly says that you are trying to convert some character value to integer value. This can be identified from "source type string[max=255] to destination type int32"... Try fixing this error by ensuring that both your source and target is having the same data type m...

Hi,

If you are using a sequencer to call your job, then you can capture the "WARNING" or "ERROR" message from the DS Director and proceed further with your requirement.

Hi,
Use a CDC... I guess you are referring to Change Data Capture Logic.... Try using a CDC and let me know if your issue got resolved or not....

Hi, As Ray has rightly said, any OUTER JOIN will fetch you NULL if you are referrening to a particular column from the Reference Table (Table on which you are performing the Outer Join). If you already have a Transformer Stage after you have performed your Outer Join, then probably use a NullToValue...