DSXchange

Hi,

How to perform data validation on fields that are changing weekly ?

I have created delta files (Sequential files)USING " cdc stage" but these are big enough as full size volume (5GB) to cause crash on server

As a Data Stage Developer .what is the scope ???

@ray, Sorry If I made you confuse ..its the Hashed value not the file . Its the Hashed filed (gerated already by using Java hash script algorithm)present in Dataset. I am performing join with some join key. My target File is Seqfile: Dataset (Hashed filed) ^ CDC Stage >>>Join >>xfm >>>>>Target (Seq ...

Hi , Job Design: Previous days Dset Dataset (Hashed filed) ^ ^ ^ (hash key look up) Todays Dset>> CDC >>>>>>>>> >>>>> join >>>>>>>>>> >>>>>>xfm >>>Seq file Error: /opt/etl/Ascential/DataStage/PXEngine.752.1/etc%%LI NK%% -APT_PMsetupFailedFlag /opt/etl/Ascential/DataStage/PXEngine.752.1/bin/osh -APT_...

Asked: 1.Data trasformation for Date fileds. What transformation are you trying to do? Re: For Example,I have some date fields present has Nullable as source so I want to give Default value in my target as 0000-00-00 if it is NULL Asked:Qn:How to Validate the data in Target files ?? What to validat...

Hi All, I am using Datastage V7.5.2 .. I Used the Chage capture stage to capture the changes in my source data. OR In general source >>>transformation>>>>target (thosands rows) (thousands rows) Transformation: 1.Data trasformation for Date fileds. Qn:How to Validate the data in Target files ?? My Un...