DSXchange

I am new at Datastage ..

I am getting these 30 - 40 warnings about violating a Unique Index on a column..
the warning is [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.D_Employee' with unique index 'D_Employee_NK'.

How can I handle this ?

These are the errors ##E IIS-DSEE-TFOR-00089 09:17:02(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed. ##E IIS-DSEE-TFOR-00089 09:17:02(002) <APT_CombinedOperatorController,0> The runLocally() of the operator failed. ##E IIS-DSEE-TFPM-00040 09:17:02(003) <APT_CombinedOperatorControlle...

I have Transformer,SQLServer stage,funnel stage ,lookup stage, Sort stage, Aggregrator stage

Hi I am not able to view data from a dataset this is the error it gives ##I IIS-DSEE-TFCN-00001 09:00:38(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.1.0.5447 Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved ##I IIS-DSEE-TFCN-00006 09:00:38(001) <main_program> c...

How can that be done?

what does this info mean

process meta data not available in database.

I have set APT_DONT_OPTIMIZE_MODIFY but what value should be given to this variable?

well before the error this info is generated

Process meta data not available in database


The job is load job and contains scd stage,Join stage,and sql server stage as look up...

hope this helps

what does this error mean

main_program: Fatal Error: The interface is not bound.

the job does not use transformer this is the design its simple mapping oracle->filter->sqlserver The thing is when I am filtering data on a value (in oracle query iam giving condition where the <columnname> <> <value>)its finishing ok but if I remove this condition the job aborts if I run using cond...

In my job 1 row(or many ) is giving implicit conversion error . how can I find the row which is causing trouble in thousand and millions of rows.The column which is having the error is not any key,can accept nulls and has datatype float. this is the warning : Copy_of_MAXIMO_WORKORDER: When checking ...

does anyone know how i can find the row or rows which are giving errors

I have tried to use modify stage but it does not work I am still getting this warning Filter_61: When checking operator: When binding output schema variable "outrec": When binding output interface field "ABBESTDOWNTIME" to field "ABBESTDOWNTIME": Implicit conversion fro...

the cast function also does not work
cast as varchardoes not work

Modify stage does not work...
this is what i gave in the specification

ABBESTDOWNTIME:sfloat=ABBESTDOWNTIME


is this correct