DSXchange

Hi,

You cannot have nested conditions in Modify stage. Use the transformer for this scenario.

HTH
--Rich

Hi Ravi, What took you this long to post your first question? The first step is always to go through the product documentation. Since you are on 7x check the Manager Guide for Configuration file topic. Once you are familiar with the product and documentation and if you have any questions do your hom...

Hi Senthil,

Do a search. You will be able to resolve it sooner than expecting a response.

--Rich

Hi,

This type of hangs usually happens when there is some kind of record locking. You do a delete. You do not commit and you issue an update command.

Did you try to sepearte the Delete and Update streams?

HTH
--Rich

Hi,

Check this link. viewtopic.php?t=97043. You should use the CDC for finding the delta values. Use the Lookup stage in conjunction with Column Generator stage to get the maximum surrogate value and to generate new surrogate key values.

HTH
--Rich

Hi,

Do a search. The problem is because of the difference between the incoming format and the expected format of the timestamp field.

HTH
--Rich

Hi,

Try to do a FTP from the unix command line and let us know what happens.

--Rich

Hi,

The Export and Import options are available in DS Designer. There is no coding or syntax required.

I recommend that you go through the documentation.

http://dwbalie.googlepages.com/dsbooks.pdf

This is the DS 7.5 documentation but good for a start. Go through the Manager Guide.

HTH
--Rich

Hi, How to check the plan in datastage? The plan in Datastage is nothing but the job score. Set $APT_DUMP_SCORE=1 and check the job score in the director. There will be 2 scores. One from the license operator. The next one is the actual job score. The job score gives information on the number of pro...

Hi,

The GUI export is the one that is available through Datastage Designer.

--Rich

The Cognos BI forum does not have a moderator and there has been an unwanted post with the heading "Free Credit Report".

Editor/Web Master pls delete the post and take necessary action on the poster.

Thanks,
Rich

Hi,

How about using row generator and generate a dummy record. Load the dummy record along with the dataset records. If the dataset is empty then the dummy record will get inserted.

Use close command to delete the dummy record once the load operation is complete.

HTH
--Rich

Hi,

Try using the DRS or ODBC stage. We had some issues with Memo fields and then we used the DRS or ODBC stage to resolve it.

HTH
--Rich

Hi,

Do a search. It is very effective.

Are the DB inputs parameterized? Are you providing the correct values for the parameters? When you do the view data how many parameter inputs show up?

--Rich

Hi, We used to face the same issues with Teradata multiload stage in DS 7.5. We could not use the $. What we did was to create local job parameter say DS_LAND. Then we use the actual environment variable say $DS_LAND in the Job Sequence as a parameter. We map the $DS_LAND to DS_LAND in the job activ...