DSXchange

Hi

Rightly said by Ray it may be possible to read same Dataset by two different jobs if you specify same processing nodes This is necessary because Data in Dataset recides on Nodes.

I had simailar kind of problem.
The issue could with the metadata. Are you able read the data in the first job properly.

Hi I three Datasets from which I am reading data , Dataset A, Dataset B and Dataset C. I am generating a Dummy Column. These three datasets have output to three Column Generators which generate the Dummy column value as 1, 2 and 3 for rows coming from Datasets A,B and C respectively. Records from th...

Hi I three Datasets from which I am reading data , Dataset A, Dataset B and Dataset C. I am generating a Dummy Column. These three datasets have output to three Column Generators which generate the Dummy column value as 1, 2 and 3 for rows coming from Datasets A,B and C respectively. Records from th...

What is NextBuisnessDay? Do you mean that if the date is any weak day other than Saturday and Sunday then it is a BuisnessDay In that case you can do on thing 1900-01-01 is monday. So you can use the code Mod(DaysSinceFromDate(InputDate, "1900-01-01"),7) Now based on the Mod value you can ...

You can do a look up just before inserting and use only those records which fail to match in the lookup Stage this would solve the issue of duplicates.

Rigthly said you can use Stage variables to hold prevoius record's value and use it in current record. Stage variable are caluculated in the order they are defined.If you set default value for a stage variable you avoid teh @INROWNUM also

If you are looking at incrementing the date you can you functions available in transformer You can get days between two dates and add appropriate multiple of ther frequency and get the date back. let us see for quarterly(90days) DateFromDaysSince(90-Mod(DaysSinceFromDate(Date1,Date2),90),Date2) Step...

Hi, With Datasets you have the advantage of parllellism in reading and writing. Though you have the option of multiple readers in sequential file, there you cannot yuo vriablelength columns. You have to use fixed length columns. By using datasets you have advantage of multiple nodes reading use vari...

Hi,
When do we use a modify Stage anmd what are its features?
Apart from changing the data type droping or adding columns,
what else can we achieve through Modify Stage?

Hi When you have a join or lookup with only one output link ( matched and unmatched records come in same link) you can identify these records by fetching a not null field from the reference link. If you have any such column, then it should be made nullable yes on the output link. Then on the output ...

In general DS treats all default numeric vales as decimals.
In Aggregator Stage output is always decimal. If you really want an Integer result you may have to type cat the result to Integer.

Hi can anybody suggest some place where to find manuals or data on the list of Unix commands that can be run on DS like Any help would be greatful.[/code]

You can check the RowSPlit Stage in server canvas.
Pivot Stage will convert columns to rows.

This can be done at any point but why does this happen is my question. and if we get any such messages how to know where the problem is