DSXchange

Hi ,
Can any one tell me the difference bet ween Sequential file and Dataset?
Can we delete the Dataset?Can we copy the Dataset?

Hi ,
My reference file has 15million rows of data ,source file has 500 rows due to lack of cache for reference file the jobs gets aborted (source and referencs files are sequential files)

How to handle this situation for better performance.

Hi ,
can any one suggests how to call a environment variable in the job level that is already defined at the project level

ray.wurlod wrote:Somewhere like C:\Program Files\Ascential\DataStage\Templates

Template categories become sub-folders in that folder.

The templates themselves can be viewed with any XML or text viewer. ...

Hi ,
Thanks for your response, could you please tell me how to export the templates.

Hi all, I created the a template from a existing job design and I got the message that the template was created successfully. But I was unable to view it from the repository of designer. can any one give some information on this ,like where these can stored ,from where we are able to access,what are...

I didthe same for first two files ,for the third one I wish to use reject option insted of putting condition for that also. I guess Ray has already replied to this query. :roll: Read Ray's second previous reply. I am able to view the part of the message ,what should I do to view the full message

Without a reject link (which is what you originally asked about) your final WHERE condition needs to contain the logical inverse of the combination of all your other WHERE conditions. For example col ... hi ray , My requirement is like this ,I has one source and using the filter I need to send the ...

The complete set, if you please. The message suggests that you have nominated link number 11 somewhere (numbering starts from 0). We need to determine whether that is the case. You can post the rel ... Hi ray , I changed the link names ,numbered from 0 ,it works fine. In this case I have given the ...

Please post your complete set of WHERE specifications from your Filter stage. Without them it is impossible to advise. ... Hi ray , I mentioned the where clause like this where clause = SID = EA1267D under that subproperty is output link = 4( Ihave given the output link number) This is for first fi...

Hi All, I need to design a job which includes a filter ,in filter I need to filterout the incomming data and route it to three files by mentioning the different conditions(Ex emp no =10,emp no =20 ,and third one is reject rows. I did in this way in filter properties tab I mentioned the where clause ...

Set the Final Delimiter property value to None. If you have only one link in the job, you will need to put some innocuous stage (such as a Copy stage) between the two Sequential File stages. ... Hi ray, I tried by putting none for the final delimeter option even I am getting the output with delimeter

Hi , I need to extract the data from a sequential file and load it into a target which is also a sequential file. The thing is source is a delimited file with first line as column names ,I can view the data in the source using "view data option" in the source stage. I want the target also ...

no way to set the data type of your colmumn into "date"? it will be easier! hi gbusson, how can I change the data type of a column when the data is present in the file ? When I change the data type of date column in the column tab of sequential file stage, I am unable to view the data in ...

ray.wurlod wrote:What IS "the source"? What data type is your date column? The answers to those questions will help a more targeted response to your questions. ...

hi ray,
The source is sequential file .data type of that column is varchar.

Hi,
In the source the format of date field is dd-mon-yy(ex : 29-apr-05).
I need to extract the month number from it .and apply some more functions on this field .(probably date functions) ,to apply date functions the format of the date must be dd-mm-yyyy. how to solve this.