DSXchange

Do the null handling in column meta data ..it will remove the warning

The output of Aggregator stage is always of double data type and as per my knowledge there is no concept of null in Double data Type .so you will never get Null as output.. Just to help your requirement ..Change the Null to some diffrent character before sending it to aggregator stage and then proce...

I think you have not defined the source and target column mapping properly.Just try to drag and drop all the column and check if it compiling ... If it works..use the applied functions one by one to each column

You can do the null handling at column level.Go to column meta data double click on the number ..it will pop up another window..there you will have to explicitly define the value in pace of null...Do it by selecting Null Field value = ' ' ...The number of spaces will be the same as the length of you...

You can do the null handling at column level.Go to column meta data double click on the number ..it will pop up another window..there you will have to explicitly define the value in pace of null...Do it by selecting Null Field value = ' ' ...The number of spaces will be the same as the length of you...

Sorry to bother you again..but again where do i execute this command ..
If in Administrator then then the output is "crontab is not in your Voc".Please guide ..Thanks

Thanks DSGURU..
I did that... even i deleted the job and reimported and then scheduled ...but no luck

Hi All, I had scheduled all of Datastage parallel job last month using director and the jobs were running fine.but for past one week it is not getting triggered.When i am scheduling the job for the same day by checking the radio button of today and scheduling it for any time it goes well..but when i...

It Seems there are some other problem..
did you try (input_link.column[1,40])
and what i will suggest is...do not do any transformation..just try to send it ..it should automatically take care.

You can use convert function...It should do for your requirement

Thanks for the inputs..
I tried ..But it is not working...

Hi All, I have one requirement where i have to send mails to many recipient.I m using Send mail Activity in job sequence...I m not sure what the delimiter should be..every time it is givng some error..I m able to send mail to one recipient but not more than one..how do i go about it.Please help. Err...

All the above example of records is only for single column.how do i write the if-else condition.If data contains $ABC then replace it with A else if data contains $BCD then replace it with B else if data contains $CDE then replace it with C and so on....

Do this: Field(in.Col, "$",1):Field(in.Col,"$",2)[1,1]:Field(CONVERT('ABCDEFGHIJKLMNOPQRSTUVWXYZ','',Upcase(in.Col)),"$",2) Get everything before the dollar sign, concatenate it to the first character of everything after the $ sign. Then finally get rid of all your alp...

Hi All, My requirement is to convert the data based on certain conditions.I am explaining the problem using an example. If data is like 12345$ABC6789 then populate data as 12345A6789 if data is like 12$BCD3456789 the populate data as 12B3456789 if data is like 1234567$CDE89 the populate data as 1234...