DSXchange

Hello All, I am trying to import one of my previous project's job design into our current project to check the design,bcoz one of the requirement is as same as the old project. But I am getting an error message like'This Item has no design time information ' when i tried to import that old project's...

Hi All,

Can any one please let me know where to set the Transaction commit size in SQL SERVER.

I'm Looking something similar to APT_ORAUPSERT_COMMIT_ROW_INTERVAL in oracle.

Thanks in Advance

Hi Craig,

Yes, we need to go back to the service provider.

Thanks

Hello Every one, Is there any Environment variable to commit all records at once (Single Commit) in SQL SERVER. I have gone through the documentation but I could n't find any information regarding the single commit. Can any one please let me know how to do single commit on sql server. Thanks in Adva...

Yes u are right Ray..

My question is, Is it Ok if we dont manually delete the table definition reference details from the stage for each column..and let it pass along with the job during UAT deploy?

ray.wurlod wrote:Parse into separate columns then run these through a Pivot stage.

Thanks Ray
But the value of 'n' is not fixed.
please suggest.

hi,

how to split multiple records based on delimiter

source is 1#2#3#4#5 ..n

it should be present in target like this
Ans
-------
1
2
3
4
5
.
.
n


Regds
Ramesh

Hi, We have jobs (in DEV) having Oracle Enterprise stage where in the columns have a value for the Table Defintion Reference pointing to the corresponding metadata residing in the Repository. When we deploy such jobs to the UAT Environment, do we need to export the metadata as well or only the job d...

Can any please let me know how to commit all transaction at once in Sql Server.

any Environment variable.

Thanks in Advance

I coudn't find any ENV variable for the SQL server Transcation commit.

In SqlServer Enterprise stage there is a option (Insert Array Size).
If I define Insert Array Size below 1 job is getting aborted.

Thanks in Advance

Hi, We are using Dataset in one of the jobs. We are using the update policy as "Overwrite" for Dataset.This job is running fine but some times we are getting like below. Error updating ORCHESTRATE File Dataset descriptor segment information for '/tmp//meas.ds'. Error while truncating data ...

We are using STP stage but we are having problem while selecting multiple records as output. Its working fine for a single record output.


Thanks in Advance

We are using SqlServer Enterprise stage.
so please let me know what options to use and where?

Hi DSGuru, I faced similar issue today. There are 0 warnings in this job. The event type of below message is 'Info'. In such scenarios, I would want the job to abort. Is there a way to achieve this.

Hi,

Could any one help me on this below warning and how to resolve.



TRN_VALID,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.



Thanks
Vijay