DSXchange

What is the vloume of your lookup data ??? If it is really huge then using lookup is not advisable. Go for Joiner with a Left Outer Join option. Then lets see whether you still get this error.

Use a Column Generator and restrict it to 1 Column value with incremental integers (1,2,3,4,5....)

Hi,
Is it a decimal column ??? Your error message seems to be something like a value exceeding the available limit of the size in DataStage column level. Check that first.

Regards,
Ajay

You can use NullToValue() or NullToZero() in Transformer Stage or you can use NVL() at source DB Stage.

Your Choice

Regards,
Ajay

Hi,
Try using a Modify Stage to convert the Int into Decimal. This should help solve your problem.

Regards,
Ajay

Hi,
In a basic routine you can achieve this logic. You can get the number of records processed per Link in your job in the routine. Call this routine in your job/sequence and then pass the same to your parallel job.

Regards,
Ajay

Hi Jag,

You cannot achieve this using a Copy Stage because down the line it will create issues.

Hi, Is your flatfile Delimited or Fixed? Cause if you are modifying your file extension alone, you will not impact the delimiter within the file. For your delimiter also to be changed you need to manually open your file and change it or have some perl script called through unix and modify the delimi...

Hi,
You can still retain your first record from first dataset into a funnel by changing the funnel type (which is by default Parallel to Sequencial).

Inside funnel properties you have an option to set sequence funnel. Try that out.

Hi,
The UNICODE error is a very strange error. If you have defined the STRING fields in your job as Unicode, try making them as 'Non-Unicode' and reimport the metadata back to the job. This should fix your problem.

Hi,
You cannot set the password parameter as a public key. You need to MASK your password value in Unix and then pass it as a parameter to the file.

Hi,
Include the header file JOBCONTROL.H in your code and then try executing your DS Job. It should work.

Hi,
Delete your DataSet from the location using DataSet Management and then try running your job again from the beginning.

This should solve your problem. If this resolves your problem i will let you know what was the problem.

Hi, In your Oracle source stage are you giving the parameter values which are defined in the Parameter section? {user=#GetPROJDEFValues.$stg_ETLJOB_ora_USER#,password=#GetPROJDEFValues.$stg_ETLJOB_ora_PASS#} "GetPROJDEFValues.$stg_ETLJOB_ora_USER" is the correct parameter value or "$s...

Hi,
You can use this Col1:Col2