DSXchange

Hi,
Just to add to what Hiral has said,
You need to use the DateSinceFromDate function for both the values i.e Date1 and Date2, get the difference between them and then divide by 30.

Hi, The logic to identify two different invoices is not clear. I hope there is a specific naming convention for the output files. Anyway, once you identify records for invoices, you can split them into sub files as follows: In first job, you can process all the records and in the output file, you ca...

Hi Have you got this issue resolved ? I understood that you have lot of XML input formats to validate and You dont want to create a DS job to validate each. You can think of a parallel routine to validate XML. (you can pass the actual XML, validation schema as inputs to it). based on the return code...

Hi,
can you explain the requirement more clearly with 2 sample input records and expected output.

As Ernie said, you can just append the xml tags if that gets you the required result.
Else, you need to use XML output stage for each output column to convert it to XML.
Is your output a DB or a file ?

Hi, You can try the following: 1) remove the aggregator and see if you can fetch the SUM value from the DB itself. 2) remove 2 transformerrs and develop the job using a single transformer. 3) i dont know your lookup logic, but see if there is any possibility of combining the 3 look ups into one stag...

It is not possible

Hi,
You cannot change the value or assign the job parameter when the job is executing. That is why DSSetParam wont work in the transformer.

You have to fetch the value from the file and then pass it to the DS job as paramter.

Hi, I have 2 questions and hope that some of you has already met this kind of problem 1. How can a sequencer job of datastage wait for a file that always change his name. For example I receive sequential files from a system that give me files named with the creation date and an id, like this: filen...

Hi All, We are in process of building a DataStage job which would call a ALSB web service to update the salesforce instance. Potentially Salesforce.com would accept 200 records in a single request. Is this something that can easily be accomplished using DataStage? For instance, if the process extra...

Hi thanks for your response. Yes the input file might have any number of records but i need to produce a file for every 50 records.I have never created custom stages before. Is there a way other than creating custom stages. Thanks Hi, Once you have the unix script for the purpose, implementing is n...

Hi,
If predicting the number of branches you might need is tough, you can try this:

Create a Wrapped stage (Custom stage)
You can call a Unix script that will partition the data and write
to multiple files.

This is just an idea.
I will also try this for learning purpose and post the result.

Hi, In this case, your target will have 300+ column names. I can see a way using lookup. Lets say your source file has all distinct ids. Your lookup will be the different lookup file sets created for each field value like name etc. But the might jobs look ugly with so many links & stages. :( you...

Hi,
One more thing you might want to check is if there are any routine activity stages that return value <> 0.
In sequences, you have the option in job properties whether to consider the non zero return values as error.
am guessing if there is a similar issue in your job.

ag_ram wrote:Hi,
Sources are predominantly DB Stages - Oracle and DB2. Targets could be files and/or DB Stages (Oracle and DB2).

Hi,
Actually am thinking if we can capture the records with length issue using a reject link for the target stages.
can you try that and let me know.

balu536 wrote:I have 0 warnings in my director log

Hi,
can you give more details about the column derivation method you are using and what are the keys you have specified?