DSXchange

You should have the data in sorted order on the primary set (on which you are aggregating) before applying the aggregate function. If its not in sorted form, then it can give wrong results.

Hi, I have a very simple probelm but I am not able to resolve it. In a job, I am having a transformer stage, where I am having suppose 4 conditions based on which 4 output files will be generated. In scenarios, when my input records satisfy only 3 conditions, then the 4th file should not be created ...

Hi,

Where should I post the queries related to Plugin stages,
Can I create my owm plugin?

Thanks,

Hi,

I am struck in a problem.
I am having two jobs.
In first job, I am assigning some value to a stage variable in transformer stage, which I want to access in my next job as job parameter.
Is it possible to do ?
If yes, please guide me.

Thanks,

Hi,

Can we specify the input as an excel sheet in datastage? (.xls)
I tried with tab delimiter but its not working.

Thanks,

Yatin Mittal

Hi, I have got the answer for my question. Actually the key element to be specified in XML stage is for generating the output files on its basis. This will be the repetition element of the XML records. If you designate the XPath expression /customers/customer/name/text() as the repetition element, X...

Hi, My input data is having a Composite Primary key consisting of two elements. I am unable to give two elements as key field in an XML stage. Also, if I specify one element as key, some times it take duplicate records also and some times it ignores those records. Can somebody guide me in this conce...

Hi, CFF can only be used as Input stage. We want data type to be in Comp - 3 format in target file. Bue the routines you are mentioning and CFF, can work in reverse order only i.e. these convert Comp -3 to Any datatype. But our requirement is reverse. Please look at it and give me the solution. With...

Hi,

I have to convert the datatype of some fields to comp - 3 whose storage is 1/2 byte.

can any body help me in this?

With Regards,

Hi, I am facing problems in converting the input XML file to GDG Binary format. I have to assign Comp - 3 datatypes to some fields also. I have tried using Complex flat file, but it accepts data in such format but it does not do the reverse. i.e. we can't make Complex Flat file as output stage. Plea...

Hi, I am unable to work with taking XML as input file. I am totally new with XML transformations. I have gone through the XML help provided with Data Stage but unable to run the job. Can you please give me step by step points on how to take XML as input file. You can take output in any format. Thank...

Please give a step by step procedure as I dont know anything about this.

Thanks in Advance

Yatin Mittal

Hi The problem may be that when you execute the DOS command, at that time it doesnot execute means there may be some problem in that in the sense the command is creating some error. As sometimes it works, this shows datastage job is fine . If you restart, then it works, means then your command get t...

Hi, Shared containers are used as reusable components for reducing the complexity of the program. you can make a container shared or local. Shared container can be accessed by any job but local container can be accessed by only that job (especially used to reduce the complexity of the job). For maki...

You can view the job log from the director or view job log option in menu in Designer.

With Regards,

sasi_kumarreddy wrote:Hai all,
I want the job log, which is generated when a job is run, into a file.
Can any body help me in doing this.

Thanks,
S K Reddy