DSXchange

Hi All, Error: jobname: Bad dboption list.Failed on Expected value for property "parameter1", got: ",", line 1 Expected value for property "parameter2", got: "}", line 1. we are passing the parameter to the jobsequence through a parm file. This sequence has th...

Thanks a lot All.

I am able to create the table and truncate it for each and every run by using the Replace option.

Thank You.

Thanks,
Anand.

Hi Chulett, My apologies for the above replies. Yes, the requirement is to drop and recreate the table for each and every run.We actually were able to create a table and load it from the file, using the 'Teradata Enterprise stage'. Now, we would like to get some advice, to drop and recreate the tera...

Hi Sagar,

Job is finishing successfully.
But the table is not getting created.

Any idea? not warning is there in the job as well

Thanks,
Anand.

Hi Sagar,

Thanks for your reply.

We only have two stages in Teradata. they are
Teradata enterprize
Teradata multiload.

I am not sure about the Teradata Px stage.

Please suggest.

Thanks,
Anand

Hi All, My requirement is to design a job which would create a table (teradata) by itself and should get loaded from the input file. File ------- transformer --------- TD table. The TD table will not exists in the DB, we need to create in the job itself. Could any one help in this, as I am new to TD...

Hi All,
I have found the option in the jobproperties, one of the tab is perfomance.

Hence I would close this topic

Hi All, Could anyone let us know, where to check the below properties of the Link-collector stage. inter Process buffering,buffer size and timeout. We actually have an error in the link-collector stage, with the below error: JobName..clctGeo: |Error 11 in GCI Link initialization.| I found in some of...

...and your user are still connected to SQL server when you try to import the table? ...and the DS user have the right permissions for the database? Hi Sussane , Thanks for your support. Actually, there was change in the DSN of the Database. New DSN has been added. Now its resolved. Thanks, Anand.

Hi Sussane,

Thanks for your quick response.
Its a global temp table only. I have already created such tables, which were importable. But this alone is creating a issue.

Thanks,
Anand.

Hi , I have requirement to load the data from source table to a temporary table. I created a table, and am able to select,describle it in Database. But when I try to import the table definition through DataStage, I could not see the table. Even, when I run the job by defining table definition manual...

Hi ,

Thanks a lot for the quick response.
I was new to sql server and was trying with the datastage.
Now, I have handled in the query itself as suggested.

Thanks,
Anand.

Hi, I am getting a waring while extrating the data from source to target. The data type in the source table is bigint identity and I need to load it into the targer as integer 10. when I ran the job, am getting the below warning. When checking operator: When binding output interface field "UNIQ...

Hi All,

Could any one suggest me on the NLS settings that needs to be taken care in handling the special. Please let me know, if there is anything that needs to be done from the Admin side as well, so that we can display these special characters.

Thanks,
Anand.

Hi ,

Thanks for you reply,

Here the column is a description column, where the datatype is nvarchar.
And we will not be able to have that unicode option checked.

Please let me know, if we have any workarounds.

Thanks,
Anand.