DSXchange

Hi Experts,

I have requirement like

For eg:
In.col1=01-01-2007
in.col2=01-03-2009

i have to take how many months are there in output between two above dates.

Please let me know how to achieve these.

Thanks in Advance

Thanks nani it's working

Hi Experts,

How to eliminate leading zero's for the integer:

Input Output
0000101-----101
0010023-----10023
0000045-----45


Can anyone help me on this?thanks in advance for your reply!

Hi Mike,

The issue was as you told i recreated the table with my own structure,now it is propogating as expected

Thanks Mike for your reply

But when i saw the source data it is different.

My source field is char(15) is there any thing we have change in the transformation part ok wil try get some sample record at the o/p it is populating 0.00 has output for all the rows.

pradeep

My source field is char(15) is there any thing we have change in the transformation part ok wil try get some sample record at the o/p it is populating 0.00 has output for all the rows.

pradeep

WHAT CONDITION I HAVE TO GIVEN FOR GETTING THE REJECT RECORDS IN MY CASE.

THANKS,

1.sTAGE vARIABLE :if IsNull(PURCH_TRANSTN_COND_Cpy1_ln.CURNCY_MULTIPLY_FCTR_VAL) Then 1 else PURCH_TRANSTN_COND_Cpy1_ln.CURNCY_MULTIPLY_FCTR_VAL THIS COLUMN IS TAKEN FROM SOME OTHER TABLE OF DATA TYPE CURNCY_MULTIPLY_FCTR_VAL DECIMAL(15,12). 2.SOURCE : I HAVE MULTIPLY WITH ABOVE COLUMN WITH SOURCE W...

Hi Mike, Thanks for the reply, Even i tried that,I checked the otherwise option in transformer but all the record are propogating in both the output. In my requirement my source is string and i need to multiply with decimal for the string field of datatype decimal(15,12) and i have converted that st...

Hi ray, i have turned the combinability mode to 'Don't Combine' still it is generating same warning dropping record PURCH_TRANSTN_COND_Xform,0: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record...

Hi Experts, Source column is datatype is decimal(15,12) and o/p column datatype is decimal(12,2). APT_CombinedOperatorController(1),0: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record dropped....

Hi Experts, I am pulling data from ABAP R/3 ,my source datatype for the field is decimal(15,3) and target is integer(10) i am using Multiload stage with Tpump has option. I am just propogating the column is that i have to handle any conversation.please suggest. I am getting this error how to resolve...

Nripendra Chand wrote:Also which stage you are using to load records into Teradata?

Unicode is disabled

Thanks for the reply.

I am Using Multiload stage with Tpump has a option.