DSXchange

What is divide by zero rule?
Why is it implimented ?
How is it implimented?

Thanks a lot :D

I have 7 employees coming in a single stream whose salary is different on Monday ,Tuesday and Wednesday.
Now I want to calculate
1) total salary of each employee.for three days..... after that
2)the employee who has max salary

How can I impliment this in DS

1)I am using a dataset in multipla jobs ..its an intermidiate file
what propogation flag shoul I set ..where its an Input stage ??

2)I have set the reference dataset link partition to entire in the look up stage
is that ok ..??

My .xls file with changed extension .csv is present in unix box..
I am not able to view it thru cat command also

HI

I have changed the extention of the .xls file to .csv ..but still I am not able to read the file thru Sequential file stage ..
is there any thing else I need to do..may in format tab..

Thanks

Hi A job in my project has failed giving the following error. Join_343,1: write failed: Output file full, and no more output files Join_343,1: Fatal Error: Tsort merger aborting: mergeOneRecord() punted Join_343,1: Fatal Error: Pipe read failed: short read Join_2,0: Fatal Error: Unable to allocate c...

Thank u very much

Can any one please send

Best Practices for coding in Datastage.

For example.
1)Null handling must be done.
2)Parameters shud not be hard coded.

READ_D_Equipment is not a field its a stage name

I am getting following compilation error I dont understand why ? can anyone please explain Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 09:05:13(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.1.0.5447 Copyright (c) 2001, 2005-2008 IBM Corporation. All rights...

Hi I have a load job in which there is One SCD stage, a Join Stage. Data is being loaded into a SQL server thru a SQLServer Stage. the insert mode is update then insert. My Primary key is the surrogate key which is Employeekey generated by the SCD stage. I am getting Primary key violation Warnings. ...

u mean deleting each stage one by one

I am getting these errors in a job where I am inserting and updating records in MS SQLserver stage D_Employee,1: Failure during execution of operator logic. Fatal Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '@P7'. Player 30 terminated unexpectedly. APT_PMsectionLeader...

The info I gave was incomplete Before adding 4 columns in the job it ran fine after adding the columns it is giving warning on a column which I did not modify [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.D_Employee' with unique index 'D_Employee_NK'. ...