DSXchange

Hello Datastage Gurus, In server job, there is CRC32 Function use for incremental loading and for this job different stages use like transformer,rowmerger,rowspilitter,hash file etc. However i want to do same job in PX.There are no such kind of stages so how can i create same job in PX ? Please sugg...

Hi i have handlled explicitly like If IsNotNull(linkname.columnname ) Then linkname.columnname Else Str('0',12) : '.' : Str('0',2) in the transformer stage despite records are dropped Thanks The basic rule in PX jobs is that if a column might contain null values then the nullable attribute MUST be s...

Hi Arnd, i have columns which have nullability NO in table defination and i have put them nullability YES in DB2 stage. I am doing and handling in transformer stage. Though in many such type of columns i am getting null values in the input data but they are getting process properly except few column...

Hi , I transfered data from db2 stage to Transformer stage to sequential file.any way i have handlled null value in Transformer stage, i got warnings in transformer stage only, that means my records are dropped before transformer stage.Though i am able to see records while viewing DB2 stage. Thanks ...

Hi, i am migrating data from db2 stage to Sequential file. yes there is null values for some records, however i have handled the null values in Transformer stage. Thanks Hman Hi Pls check that column getting any NULL values. If null values possible handed null in your SQL query it. Which stage r u u...

Hello Datastage Gurus, in my datastage job, i have several columns and i have handled null value for each column also. However some records dropped for few decimal field columns, and gives warning messages like "Format_NV_Tfm,0: Field 'P_MKTPRC_BAM' from input dataset '0' is NULL. Record droppe...

Hello Friends, I have 9 columns I have transfered data from Db2 stages to Flatfile columns are like Fund char(4) Asset_id char(9) Name char(24) Source_code char(1) Sec_type char(1) shares char(14) Price char(10) Zerofill char(10) MktVal char(16) Total length is 80. when i run job, job works fine but...

Hello friends, What is Run time column propagation check box in Administrator ? I have read the help like If you enable this feature, stages in parallel jobs can handle undefined columns that they encounter when the job is run, and propagate these columns through to the rest of the job. This check b...

Hi Roy,

for datatype as string it gives appropriate value.

Thx

Hman

Hello friends,

i m new to Px.

what do u mean by sparse lookup ?

regards
Hman

Hello friends I m using job parameter for date ,and datatype is date . but when i enter the date as 0001-01-01 it gives output as 2005-01-01 similarly for 0002-01-01 gives 2002-01-01 0030-01-01 gives 1930-01-01 0099-01-01 gives 1999-01-01 0029-01-01 gives 2029-01-01 can u please say what is going on...