DSXchange

Can you please be more clear on the issue.

For using adaptors / stages in DataStage whe do we you RAM requirements or temporary disk space. What adaptors are you using.

What are you trying to do.


Thanks

Did you try loading the data into Teradata table using Tpump utility.

Teradata Enterprise Stage is having some restrictions for using it as Target. Please try with Tpump and let us know.

Thanks

StringToDate function converts the date into yyyy-mm-dd.

Why do you need the function.

DateToString(StringToDate(OutDate.DATE,"%dd/%mm/%yyyy"),"%yyyy%mm%dd").

Please check the datatype of sv2. You might be assigning Date to a Integer datatype stage variable.


Thanks

Use to StringToTimestamp function in the transfer to convert the data if the source datatype is defined as String.


Thanks

Try connecting using the ODBC stage.

In manager try to find ODBC Enterprise Stage in Stage Types -> Parallel -> Database.


We are using ODBC stage to select/insert into Sql Server and is working fine.

Thanks

Hi,
Are you finding null values for all the records that are getting into the table.

Did you check for warnings in the director log.


Thanks,

Yes ,
There is a client available from IBM.
But for what purpose are you using the Classic federations.

We tried to use it to extract data from VSAM / Datacom files/tables from mainframes. Performance wise it is very slow .

Thanks,

Branded Odbc drivers gets installed by default at the time of DataStage installation.

Once you install the classic federation, you have to edit the dsenv file to include the lib directory location of the classic federation in the dsenv file.

This has to be before the branded odbc drivers.


Thanks

Hi,
Classic Federation ( Assuming it is Information Integration Classic Federation ) drivers needs to be added to the LIBPATH in dsenv file.
branded odbc libraries should be defined after the classic federation libraries in dsenv file.

Otherwise it will not work.


Thanks

Hi,
How did you try accessing the Teradata database.
Did you add the location of the Teradata drivers in the dsenv file which will be in DSEngine directory.

Which utility of Teradata did you use to connect to Teradata.

Please provide sufficient details so that we can help you.


Thanks,

Check if you have any NCHAR / NVARCHAR as datatypes for any of the columns.
The NCHAR and NVARCHAR datatypes expects that the NLS_LANG is installed.

Thanks

Hi , This could have caused because of the DataStage monitor process. We used to face the same issue. Once the APT_MONITOR_SIZE variable is set to some value , we did not face this error again. Please set the APT_MONITOR_SIZE to some value ( in our case we set to 10000) to overcome this issue. Thank...

You can load the data into a sequential file and load the data into teradata table using a bteq / tpump scripts if you dont want to use DataStage for loading.

You can even use ODBC stage to load the data .

You can load the data into a sequential file and load the data into teradata table using a bteq / tpump scripts. It all depends upon your requirement.

Sheshadri,

I understand that you want to map five fields from source into one field.

Use the concatenate operator ( ':') ( Field1:Field2:Field3:Field4:Field5)
in the transformer stage.


If this is not the requirement , please rephrase your requirements.

Thanks