DSXchange

Hi, 1.If you have a huge volume of data and there are no constraint on your target table you can go for a Bulk Stage. 2.You can use Link partitioner with multiple transformers depending on the number of CPUs of your server. 3.Select only the required columns at the source. 4.Performance also depends...

Hi Shilpa,

This looks like your source data problem.

If you are not worried about extra columns in the record you can check The option in format tab - Suppress row truncation warnings.

Else you open the file in a textpad or edit plus to trace the error record manually.





Regards,

HI,

Take the two inputs into two sequential files and try Complete Set.

Hope this could serve the purpose.

Regards,
Suresh N

Hi ,

You can import table definitions by

Go to DS Manager ===>Import ===>Table Definitions ===>Plug In Metadta Definitions.

Regards,
Suresh N

Hi,

If you are using a Bulk Load Stage you can specify Restart Count in the properties as 3001 and Load Mode as INSERT.
This will start loading from 3001st row.

Regards,
Suresh N

Lavanya, Hashed file(HF) stage acts like a database table. You can use HF for eliminating duplicates, use as reference link, stream link ... But using HF as a lookup stage has its own limitation to its volume of data. In a 32 bit machine HF can grow to a maximum of 2GB and in a 64 bit machine it can...

Dear All, We wre getting following error while executing a datastage server job. ": ds_uvput() - Write failed for record id '38890'" When we executed the job with a userid say "A" we got this error. Then we executed the job with admin userid. Job executed successfully. Next day w...

Hi Type1 - u can do it by update option insert else update. Type2 - LookUpTgt i i i source---->Transformer-------------->Target(3 links to target) Generate Surrogate Key in Transformer. Lookup the target and compare the key feild and changing column write constraints accordingly to 3 links. One for ...

Check for Line Termination option in ur sequential stage whether it is Unix style or DOS style.

Regards,
Suresh N

Hi Mahesh

Check whether ur Operating System is with Service Pack 1.

You could go through a pdf in the docs with provides all details about installation of 7.5x2 on windows

Regards

Suresh N

Hi

Please install Visual Studio Dot Net, a set of 3cds. That installs c++ compiler which is mandatory for a transformer to work.

Regards
Suresh N

Hi

Could anybody help me to get the
command to get the job creation date.

Is any possibility to change the creation date of job.If so how to trace that who changed the creation date.

This would be a great help.

thanks in Advance

Suresh N

Hey Thanks Very Much !!

Ur correct .The problem was with the NULL field .

I gave Not IsNull to eliminate that.

Anyhow thanks for ur response.



Suresh N

Hi EveryBody Please help me fast. My job is taking input from 30 hash files and output to 7sequential files and 2 hash files .these 2 hash files give output to 2 db2 stages. My job is generating warnings while it loads into one of the last two files and the warning message is ds_uvput() - Write fail...

Hey

i tried like this in the derivation part of transformer

Ereplace(Fieldname,""","")

The above derivation is not accepted

Provide me the solution please .....