DSXchange

Thanks for your reply chulett. right now I am not infront of datastage. But I am going to write a derivation like I mentioned below. StgVar: If Inlink.Item<>"100" Then 'Y' Else 'N' Constraint: StageVar='Y' Abort After rows=1 Hope this logic will abort my job. Please let me know, If do anyt...

I have tried with utility abort log option. But job got failed. I need to abort the job when the condition is not met.

Hi All,

One of my source file column name is Item where records are like below

100
200
300
100
100

If any records come other than 100 in Item column, I need to abort the job.

Any help is really apprecidated.

Hi All, I have one question. Suppose we are running our job with 10000 rows. While running the job, the job got aborted in middle. Now out of 10,000 records, 5000 records are loaded in target. For this kind of situation normally we will use sequencer. We will enable the check point options. Then seq...

Hello Everyone,

I have a file with 10000 records. While loading the records into the target, the job got aborted at some point.
I need to fetch the record on which the job got aborted.

Could anyone please advice me, how to find on which record, the job got aborted?

Hi All, I have one flat file which has 3 columns. I have mentioned below the metadata of the file. ColumnName DataType Name Varchar 6 Salary Varchar 6 Company Varchar 6 My problem is There is no delimiter in any one of the records. All the records are in sameline. Ex: Pravin50000GoogleMoses70000Targ...

Hi, I have one date column in my source table. The date i need to calculate based on four quarter months basis. Means 1st quarter - Jan to Mar 2nd Quart-Apr to Jun 3rd Quart-July to Sep 4th Quart-Oct to Dec. If my source date comes between first quarter like this Ex: 3/14/2005 then my First Date sho...

Hi Everyone,

I Can able to search one particular string in Unix using grep command like this.

grep -i "String" filename.

Is it possible to search a string in DataStage. If yes, how to do that?. Any help is really appreciated.

I am using upsert mode in my target table.

Hi, I have job like this Seq---->Transformer---->OracleStage. I have a file which has 1,50,000 records. I have loaded the data successfully in the target table But the problem is It has taken more than 10 minutes to load the data. People here rejected the job. How to reduce the load timing in the ta...

Thanks to everyone. I loaded the data successfully in my target table.

Thanks Once Again. :D

Have the Sequential File stage read the file with each line being a single VarChar field, then parse that in a downstream Transformer stage. (This is actually more efficient, as the parsing occurs ... Thanks for your reply ray. But what delimiter I have to put in the Delimiter section in sequential...

Hi, I have received different source file. In my source file has 6 columns. The records are in source file has different delimiter in all the columns. The records are like I mentioned below. column1 column2 column3 column4 column5 column6 1001 |Josh,US*Toys 2011 For one record is having different de...

Hi, My Source is a File and My data's are like I mentioned below. Column1 Column2 101 James 101 204 101 US I need my output like this EmpId Name Zipcod Location 101 James 204 US. Multiple records value I need it in single records. How to do that? Please help me to get rid of this Issue....

Thanks ds. Really your input helped me a lot. I fixed my problem. Thx once again