DSXchange

First off, you can't have more than one Input link to a transformer. :? Its way of writing, reading or thinking. I know, there could be only one "Mainstream" and remaining "Reference" link. And as each of the link would be sending some data to the transformer, i would call them ...

I want that the value be assigned based on number of input rows from one link Then use @OUTROWNUM instead. :wink: This wont help, he want count of records coming from one of the input link out of 'N'. Say you have two input link (InL1 and InL2) to a transformer stage (Tr1) and one output link(OpL1)...

... and how do you think the tail command works out which are the final lines in the file? :roll: Definately it does not reach tail or end of file, by reading through all the lines :shock: and keeping the count. if I remember exactly, It looks for End-Of-File Mark in the last few bytes and reads ac...

If i dont have any use of details in my header and trailer in my design, then i would avoid counting the no of lines in the file, if your file size is huge it would take time. Another way could be, remove the Tail of the file by using TAIL command of unix. In CFF stage give start rec=1 and End rec=m...

Well guys, from the example he has given i think he is looking for merge(appending one file below the other), not joining which can be done through merge stage. But for appending , either use link-collector or you will have to write a routine. I dont know if the server version you are having has lin...

yes you are right the generated sql query will also have TO_DATE format, but the format used in TO_DATE would be some default format, and it may not be same as your input data in that case you need to have User-defined query. Again creating User-Defined query may intoduce some human error. But if we...

Can anyone clarify me about Transaction Size and Array size? Details about them can be found in the pdf documents as well as datastage help. You should try to get this kind of simple details yourself and post a thread when you have some technical difficulties. Transaction size: This is the number o...

missed out few things, again the soln i suggested is not the only thing. The soln i hav given will work if your job fails once. But what if your job fails several times, in that case , you need to get/store the counts of rejected and processed records for every run and before running the job, you sh...

You might also need to round your @INROWNUM count down to the nearest commit point. If you are commiting with a transaction size of 1000 and you fail after 11323 rows you may have committed just 11000 of those rows. If you have the transaction and array size set to 1 then this makes reject handling...

or
1. Read it as a character throughout all the stages(even in the oracle stage)
2. Write a user-defined query , in which you use TO_DATE function, with a format that matches your data format.

if your source is sequential flat file then the method suggested, using @INROWNUM, can be helpful otherwise one cannot be sure that; row processed now, was not processed in last run. If source is Oracle ordering by rownum would help as well as instead of using @INROWNUM you can avoid reading from th...

It's highly likely that the indexes need (re)building. Good practice would be to first check if the jobs in your project needs index rebuilding. Use: LIST.INDEX DS_JOBS ALL, on Command tab in DataStage Administrator, to re-build the indexes. If it requires rebuilding of index. Use DS.REINDEX DS_JOBS...

amsh76 wrote:If I am not wrong, in Oracle, it does equivalent of trim on the column and thats the reason you are getting this problem.

Sorry but you are wrong, Oracle stores spaces as spaces only. if column is varchar and its not null, it will accept spaces as its values.

Well if you follow the method that i have suggested in my first post, you would surely get it.

Sainath.Srinivasan wrote:Try OConv(YourDate, 'D-YMD[4,2,2]')

Format does not match with the input value. Looking at the value he has pasted, it should be either OConv(YourDate, 'D-DMY[2,2,4]') or OConv(YourDate, 'D-MDY[2,2,4]')