DSXchange

Thats what i did SK column bigint then transformer bigint still warning

Hi,
I am using Surrogated key generator as in oracle the datatype is number(8,0) . i am getting below warning so how can i fix this in SK generator without changing datatype in oracle?

conversion from source type "uint64" to result type "int32

Thanks

Hi, I am doing CDC somehow rows are not getting insert i am USING CDC stage then filter and based upon change_code = 1 insert and based upon change_code =3 update I think my insert mode in oracle connector is not write : i am doing Insert with table action append and same for update with table actio...

Right in some cases it don't so how to proceed then

Should not IsNull(to_transf4.COST_CNTR_TCD) take care of NULL

Hi, i am getting below results while doing IF TRIM(((to_transf4.ORDER_TCD[1,1]) <>'S' AND trim(to_transf4.ORDER_TCD<>'')) and (TRIM(to_transf4.COST_CNTR_TCD='') or IsNull(to_transf4.COST_CNTR_TCD))) then 'Y' ELSE 'N' Peek_186,0: COST_CNTR_TCD:NULL POST_STAT:N DOC_NUM:5001307000 LINE_ITEM: 001. ORDER...

i am getting same output like input so no transformation is done

Hi, I have data coming like ORDER_TCD COST_CNTR_TCD NETWORK_TCD S83010 11111 600009 33333 700006 22222 AAAAAA After transformation i want it to look like ORDER_TCD COST_CNTR_TCD NETWORK_TCD S83010 11111 600009 700006 22222 AAAAAA So basic idea is if ORDER_TCD starts with prefix S or network_tcd is n...

i did try payr_vblnr is not null or payr_vblnr <>' ' but same result

Hi, i am doing this in filter stage payr_vblnr is not null and i am still getting nulls and i am doing trim in transformer as i can't do trim in filter stage But when i run sql in oracle doing where trim(payr_vblnr) is not null it works gives me desire result I did try putting constraint in transfor...

Thats ok take it easy no comments work will never stop even if you reply or not

Sometime it is better not to reply if you don't like post.

Hi,
How can i do this extract character 11 to 16 to get col1 and then extract from character 17 to end to get col2

Example

Source

COL1
KL10000000112111205-OT
Target
col1 col2
112111 205-OT

Yes transformer did get three rows in which is good but after transformer
constraint rows_out are zero

i want to see two below rows out of transformer

105 500 506
105 101 201

Hi, I have table a table b col1 col2 col col1 b_col2 b_col3 105 500 507 105 500 507 105 500 506 105 101 201 Target result should be col1 col2 col3 105 500 506 105 101 201 i joined two table using join stage did left outer join from table a to table b on col1 then in transformer i put a constraint co...