DSXchange

Hi, We are in process of migrating 8.1 to 9.1. In 8.1, we encountered issues, when values contains copyright symbols. To handle this, we added one environment variable NLS_LANG with value "AMERICAN_AMERICA.WE8ISO8859P1". But the same is not working for 9.1. Any comments please. Our target ...

Hi,
I have about 1000 jobs in on of my project and we need to find load strategy applied in each target table. Is there any automated way to achieve this, other than opening each job.

Thanks

Change the output column data type as INTEGER in transformer and see..

Else you can pass that value to a column whose type in INT.

Did you try setting client character set as LATIN01_A in Teradata stage.

You can do that only through unix script. Through DataStage you cant

How did you try

Have you tried like this

If IsNull(Col2) or Len(Trim(Col2))=0
Then '~'
Else Col2

Check the nullability and datatype of the field that came from lookup. If it is Integer and not null, 0 will be populated.

Hi all, We have a simple job with source as DB2 and target as Teradata. Change capture stage is used to identify the delta records. Oracle connector is involved to generate audit fields. This job is a multi instance one. Job is running fine without any issues but it is taking more time than expected...

Under Reject link properties, there will be some property to mention number of reject rows based on which job will abort. Default will be 1. Set it to 0.

Hi,
We are connecting to LDAP through Java Client stage in V8.0 in our project.
Properties to mention :
1. Transformer class name
2. Users properties
a) ldap driver
b) ldap connection URL
c) ldap user
d) ldap password
e) ldap sql
3. Java library path in JVM options.

In which stage you are getting this warning. If you have any option to change character set, please try with LATIN 01A

Try with this
unzip /da/st/test.zip -d

Have you tried with StoredProcedure stage.