DSXchange

Hi,

You can have a row generator generating a dummy row which you can funnel with the data from the dataset and then do the lookup. In this case you can avoid DB stages and the job will not abort even if the reference dataset does not have data.

HTH
--Rich

Hi, Yes you have to import the required columns from both the tables into the stage and use user-defined SQL. My advise for someone new to DS would be 1. Do your homework before posting questions. Just go through the official documentation. 2. Always give it a shot. If it works good. If it fails the...

Hi, I hope you know the difference between a SET table and MULTISET table. A SET table does not allow 2 rows to be exactly the same. So whenever an insert happens the duplicate row checking happens at the background. How many columns does the table have? If there are too many columns then the duplic...

Hi Leo, These 2 parameters define the connections to the Teradata DB and is related to the number of AMPs in the Teradata Database. Talk to your Teradata DBA about the configuration of the DB. Requested Sessions = No of connections to the Teradata DB. Usually it would be the number of AMPs. Set betw...

Hi,

Did you check the link ordering in the CDC stage. The source should be the after link.

HTH
--Rich

Hi,

Search the forum for CDC topics. That should give you more information on how to handle SCDs as well as to generate SKs.

HTH
--Rich

Hi,

Enable the RCP for the job. The SQLCODE column will be propagated to the flat file.

HTH
--Rich

Hi,

How are you passing the user defined environment variable?

1. Is it part of the job parameters?

2. Use GetEnvironment() function available in transformer

3. Do not use $ when using in transformer.

HTH
--Rich

Hi,

This is what I found in the Parallel Job Developers Guide.

Before you can use SFTP to transfer files, you should configure the SSH connection without any pass phrase for RSA authentication.

Hope this information helps.

--Rich

Hi Murthy,

1. What is the stage you are using?

2. As Sainath asked what is the datatype of the target column

This is pretty straight forward. You just have to use a transformer and use the following derivation

LinkName.FirstName:" ":Linkname.LastName

HTH
--Rich

Hi,

Try to run your Teradata SQL in SQL Assistant. Once it goes through use it in TD Connector. There seems to be a problem with your SQL.

HTH
--Rich

Hi,

Make sure you have set the nullability to Yes in all the stages after the lookup stage.

--Rich

Hi,

In the transformer do not use the $ for the environment variable.

Alternatively you can use GetEnvironment(Prm_Batch_Id).

HTH
--Rich

Hi,

Make use of the option "Do not checkpoint run" in the job activity S1.

HTH
--Rich

Hi, I had a similar issue and I think I did a TRIM after doing the decimal to String conversion. The other solution was to use the stage variables. Use the decimal to String function. Use Field function to get the precision part and decimal part. Do a Trim on both the stage variables. Concat the sta...