DSXchange

I don't know how it the characters works in SQL Server but i was facing the same type of issue in Teradata, to solve the issue use the character set ibm-1051_P100-1995, use the one that is used in SQL server and that will solve the issue

I have a shared container and which is called from many jobs at the same time, i am trying to create a temp table and wants its name to be unique(Using Teradata Connector stage in PX and Teradata MLOAd in server job), as far as i know i can't parametrize table except using Job parameter. I am lookin...

Is it possible that i call a PX routine and inside that routine i add a new parameter to the job in which this routine is called and set its value, Also how to change the Job parameter value when the job is running? I am facing this problem in migrating PX shared container and i want to create uniqu...

I enabled LATIN1_0A on Teradata and use the same characterset in Teradata connector stage and its working fine now, the warning are not coming out now.

UTF also works but i wanted to check it 8 bytes per character will work or not because in the Database table it was also 8 bytes per character, i enabled LATIN1_0A on Teradata and use the same characterset in Teradata connector stage and its working fine now

Thanks toshea i already did the reject link solution, but its giving a problem, here is what i did in the job 1) Insert into a temp table(Natural Keys) 2) In the after SQL, generate Surogate key for these natural keys in a specific way, then update some tables 3) Reject the rows on success 4) Lookup...

Constraint is i have to use the same shared container

I have to redesign a shared container, and in the shared container i have to first insert in a table through Teradata connector stage and then export some data once the insert is compete, but in Teradata connector i can't read and write at the same time. Is there any way i can insert the data first ...

Have to reopen as Schema reconcilition -> unused feild action = drop does not work although i thought that is what documentation says. Have done a workaround by using a modify stage and added the drop column specification. Please let me know if there is a direct way of droping the column ?

I make it work : Schema reconcilition -> unused feild action = drop

Orignal Job: Target Stage = TD Enterprise stage RCP = ON Silently Drop Column = TRUE Changed Job Target Stage = TD Connector stage RCP = ON PROBLEM The jobs is dynamic job can be called for different tables i am looking for any option which can be used if there are extra columns coming from income ...

If these are not harmful why are they shown as warning in the first place? any particular casting that can be done to remove these warning rather then suppressing them? Secondly how to make them information at project level and whats the procedure to move these handlers to other envirnoment when the...

There table is somewhat similar to Tera_Sync table, but Tera_sync table is only used for Teradata Enterrpise stage. You can give any name like TPT_Terasync, this table once create you will see that Tera_Sync table feilds are a subset of this table it also contain some more fields. You can give one n...

I am trying to run before routine which is reading the parametrs values StatusId = JobName:'.':STAGECOM.WAVE.NUM Readv ParamValues From DSRTCOM.RTSTATUS.FVAR, StatusId, JOB.PARAM.VALUES On Error Release DSRTCOM.RTSTATUS.FVAR, JobName On Error Null Call DSLogFatal('File read error for ':StatusId:' on...

When you will use Append mode to insert data into the final table, Enterprise stage create a working table, all the rows are written into that table thats what the log is saying Rows written: 153,027,180. After this step the data is copied to target table using the following query INSERT INTO TARGET...