DSXchange

can i concatenate null values with out hanling null property

hi all, i have an reqirement like concatenation of 4 fields into a single character, but some of the fields having null records are dropped at the Transformer. for example F1,F2,F3,F4 if any one of the field having null values these recorda are not loaded into next stage,transformer stage dropping t...

Hi,

use a isvaild function to get the date values which is having proper format means dd-mm-yyyy.you can deal with rest of the dates by prefix 0.

Hi,

use a isvaild function to get the date values which is having proper format means dd-mm-yyyy.you can deal with rest of the dates by prefix 0.

hi,


now its working fine.

Thanks

Sainath.Srinivasan wrote:What is the datatype for target column ?

Data type is varchar2

nani0907 wrote:Hi,
Are fisrt name and secomd names two different columns.

Use below logic

fristname : Space(1) : lastname .

Let me know how it works.

Thanks
Sana

Hi ,

thanks for respond,

now its giving
fristnameSpace(1)astname.
not giving appropriate result

Hi all, Could you please let me know how to concatenate two values with blank space. my reqirement is some thing like concatenate lastname and fristname with blank value foe example fristname-->GIRI lastname--->KIRAN reqired reult is GIRI KIRAN So far i tried with fristname : ' ' : lastname but its ...

dscon9128 wrote:Thanks a lot, worked great!

hi,

could you please let me know where exactly execute this sequel

hi all, any one have an idea how to resolve the following issue buffer(0),0: APT_BufferFile: unable to create file 0000000000000000: Permission denied APT_BufferFile: unable to create file 0000000000000000: Permission denied APT_BufferFile: unable to create file 0000000000000000: Permission denied A...

Hi alll,

is there any way to do impor and export datastage jobs and job executables through unix commands on server side.
could you please let me know any about this.

Thanks to all in advance.

Hi,

just try with this Field(inputcolumn, ',' ,2).it works fine.

Here are the steps you could proceed with 1. In job properties, in after job subroutine tab select EXEC DOS 2. Can use the below command (copy /b /y File1Name+File2Name+File3Name FinalOutputFileName) hi , can we concatenate theree files into a single file with out using funnel in datastage.how can ...

[quote="arshi"]Hi Murthy,

I didnot found any options tab in the sort stage . I am using the server edition (7.5) . Can you explain where it is exactly?


which version of DS you areusing ?.it is PX or server?

Hi, First sort the data by using the Sort stage and use the stage variables to remove the duplicates. By using the sort stage , It will work fine for a particular month data but not on entire data. Any one have the solution for this. Regards, Arshi. hi , do one thing in the sort stage options tab j...