DSXchange

Ray,

I tried using 4,2,2 in OCONV, but it still throws the same error message.
Anything else I can try?
Infact I aslo tried using the same code via a Routine.

Also I did not understand the meaning of your first statement regards Quote..

Hi Again,

now i have found onemore record which contains 16 digits value in output(78944153.69966222).

Col1:=-84083416.1800000
Col2:=0.93887900

Output:=-78944153.6996622.

Thanks and Regards
sny_ds.

Ray, I got it what you and Craig explained. But just wanted to confirm with you if, this EXACTNUMERIC parameter in uvconfig file doesn't count signs ('-') or decimal points (.) from the values. Please let me know. It means in my first post, i had value (-234003098.0822554) of only digits count 16. S...

Hi Craig- Thanks for your reply! As you said, I have checked our uvconfig file settings. The EXACT_NUMERIC variable is '15' by default; which is pretty much higher than my target record's precision which is just '7'. (-234003098.0822554). I have another target records which are outputting fine. Eg: ...

Hi, I have two fields col1 , col2; which are defined as Decimal(26,8) and Decimal(20,2). I am just multiplying these two fields in the transformer stage and passing this value to the target, which is defined as Decimal(25,7). I had a strange truncation in one field of my output. Eg: Col1 = -24873359...

Are you trying this for incase of any job aborts,If it is the case use one uservariable activity stage and give the specific environments and in the notification activity of attachments part use the log path as attachment.

Hi, In one of my job I'm using CDC, I have to src links (hash partitioned and sorted ASC on my key). In CDC stage I'm using change mode as Explicit Keys, All Values I have run the initial run where my target has 0 records; all records got inserted. I got the change record in my source, there is a ch...

Yes, in my mapping all the columns mapped to the output from right link are nullable.
I'm not getting why my join is behaving goofy.

Thanks
Suresh

Thanks Ray for your quick responce,

Both the source links are partitioned on KEY and sorted on same before joining. The join type is left outter join ( ABC is Left).
Link execution order ABC is 1st and DEF is second.

Thanks
Suresh

Thanks Ray, The job was developed by someone and I'm doing the code review. I have to promote this job to PROD. In other CDC stages we are using only the comparison columns. I found we are using different columns in one CDC. My question is can we have other columns apart from comparison columns in C...

Hi, I want to know regarding the CDC stage. I have to 2 source links and a target link. Source1 : 30 columns. Source2 : 10 columns. Target : 10 columns. 10 columns and their metadata are same in 3 links (sourece1,source2 and target). My jobs are running fine but as per the CDC standard's do we need ...

Hemant_Kulkarni wrote:Create a Job parameter NLS_LANG and set the value as AMERICAN_AMERICA.UTF8

I created job parameter and assigned AMERICAN_AMERICA.UTF8 value. Even though I get the following error.

"Transformer_2: Pin 2 not initialized"


Could you please provide any resolutions


Thanks

What is your source? Is it a flat file or a database table? If a table then, what is the NLS character set in your source database? WHat happens when you write to a text file, do any of the characters show up? Please find the following details: Source :SQL server NLS caracter set on sql server :asc...

sun786 wrote:what is the NLS charecter set on the project?

we don't have NLS characet in my PROJECT.

Hi, I have a multiple instance dimension job, this job will have below jobs. EXT XFM LOAD SEQ SEQ calls all the 3 jobs. Invocation ID is passed to SEQ from the Script . Target and Source table structures are same, Jobs are running fine and everything is working fine for the dimensions. Now I'm havin...