DSXchange

I did not gave value for length filed while calculating SvDomain Stg. variable using substring function.

issue is resolved as soon as i provide length in substring.

I saw only records related to "comma" made me to post this topic.

Anyway thank you All!!!

Kiran

I do not see any spl characters.

here is the example

PLAINSISD,ESC17.NET

Hi, I am using a following syntax to repalce comma character and then if I find any "!" in my string I want to set it to NULL to avoid using those values. However I still see output column values with comma in it. var1 = Convert("#$%/&,;","!!!!!!!", SvDomain) and us...

modify your Stg Var. by using if then else.

if Isnull(Input) then some value else trim(input)
then reject based on value given in Stg var.

I created a new post as Brad marked it as resolved. I am not sure shall I leave my other post as open or not! it works for me however I am already using two transformers in a row to validate/filter email data. it will force me to use a third one or I need to figure out by adding some more Stg Var. I...

HI, I saw previous post related to IN however it says we have only ability to chk single char. I need to check my email host around 30 -40 host names like email_host in ( 'net','com','org') fyi. planning to do a lookup by putting all those 30-40 host names in a file. is there any chance to use IN op...

Hi, thanks for sharing about IN operator. Is there any change to filter in new versions? I am looking for IN operator with multiple characters using DS 7.5.1. Here is an example of my requirement. I need to validate email host by looking around 30-40 hosts. email_Host IN ('com','net','in','uk','org'...

try writing to datasets and process your inserts/deletes in seperate job.
I think table lock maybe an issue.
or try adding sleep & tenacity

Chulett,

Here is the Error Message..
main_program: When preparing operator: When setting up transfer or "Status_dt":The source and destination have differing nullability.

Hi, Job failed with nullability issue in funnel. though two source columns are defined as nulls in the ETL from beginning to end. fyi. table1.col1 -null ; table2.col1 -not null where as metadata is null in both ETL source tables job runs fine if I create a temp table(table2) with col1 as null. I did...

Hi,

Thank you Guys!

Its not necessary in my job however I can resolve if requirement comes.

Author,
please update is as resolved!

I am not using RCP in this job

Hi, We have a post for this but I felt we do not have enough info on that one. I am getting following waring when I pull all columns from after dataset as I have not added all columns in explicit keys & values. However I need all those columns to do another cdc to differentiate two updates. ( se...

Hi, I want to drop records if both column1 and column2 are null. Source & Target columns are defined as nullable. I am using xfrm constraint with following condition however it is dropping all records if either is null IsNotNull(COL1) And IsNotNull(COL2) ex. source 50K records. expected 3 record...

priyadarshikunal wrote:Time to mark this post as Resolved.

I am using 7.5.1 and I am doing a max on two columns belong to varchar & date.

I am unable to find preserver property in the available properties to add.

Appreciated for your help!