DSXchange

Use NullFieldvalue property of Sequential stage.

Check format/metadata of your source file, whatever value you get as Null from file for any data type use that value in NullFieldvalue.

For example it could be -

String -NullFieldvalue=''
Decimal - NullFieldvalue=0

only way i can think of ..is to split input file in 2 or more files and FTP it to UNIX server ...and then join it for processing..

Unpack it and then split it, with tools available in market...
again zip it ..
Tedious but the only one...

This is what i have done whn i faced situation like you... I have put in a lookup to same table (in my case it was table) where i check whether my already loaded 1000 rows are present if yes...leave it as it is and pass rest 9000 rows to reject link for rest of processing.. Not sure about if you usi...

In our job design, We are filtering out offending entries from the DB, after the previous copletion of ETL operation. These filtered entries we are expected to direct to a sequential file. If this sequential file at the end of the job is non-empty, is there any way we can abort the job, so further ...

ArndW wrote:guarav - the original post states that words cannot be split, which is what doing a straight substring extraction would do. ...

In that case your's solution is correct.
I understand it wrongly!

Maveric,

I have tried the same solution as suggested by you, but still its not writing to error file.

I have tried with Link ordering as well but its still not creating file. Is this something to do with Configuration file ( 1 node 0r 4 Node) or something to do with partitioning or Execution mode (Sequential or Parallel). If anybody have diffrent desgin to achive such functionality please share with...

Hi, I am stuck with a tricky scenario. I have to split a column 'customer_name' which is 100 characters long into 4 chunks. The tricky part is that I am supposed to split it at spaces and also, then max number of characters in a chunk shouldn't be greater than 35. Is there a way we can do this in D...

I have Datastage job and which verifies Header Record in a particular file, it checks that first column of header file should be 'A'. If first column record is not 'A' then it should write error message(Invalid Header) in Error File(Sequential File) and after that the Datastage job should abort. The...

We can make job multiple instance by checking the Multiple Instance Check button in Job Properties window.

Now you need to run the job through unix script with parameter as your period for which you want to run the job.

And this period will also be your invocation id.

Let me know this works or not.

I have a job which needs to abort, when a particular condition fails and write to sequential Error File with message that indicate cause of error. For which I have used "Abort After Rows = 1" functionality in Transformer, but the thing is when that specific conditon fails then job does not...