DSXchange

Is there a way only to count business days with this function?

Thanks

Based on the amount of warnings DS issues, should I be concerned with them. I try and cleanup as many as I can but due to time constraint and schedules, I am reluctant to spend a whole lot of time investigating them. The warning I know that may give me issues I fix and the others I ignore. Should I ...

Thanks, that was the solution

I am trying to select a Max(fiscal date) that is less than the current date. I only want the first record from a table. I am getting all records even if I select the maximum value. Is the Aggregate stage the only way to slect max values.

First, 10G is our repository. As for our environment, I was just using unique environment in the context that nmot all organizations have the same configuration. As for this organization, it is pretty standard setup. DataStage installed on it's own server, database on another and links between produ...

Could some using version 8.0.1 Windows environment please provide some feedback on their current stability using Oracle 10R2 as their database with Oracle 92 as their client. Is there anyone that has had datastage jobs accessing an Oracle database and their jobs hang for no reason. I talked to IBM s...

I made a mistake with my logic. The results were correct with the integer datatype. I used a copy stage to allow for two references into the lookup and I only needed one. It caused more rejects due to the extra link. The integer was correctly working. As for debugging, I will try the trace and peek ...

Hi all, 1- We had an 8 node system and could only use 2 nodes with version 8. The system would abort as soon as you supplied more than 2. 2- Multiple Join Stages would abort the jobs. 3- Multiple Aggregate Stages would abort the jobs. We ran two servers, one with 7.5.x2 and 8.0. The 7.5.x2 version w...

I read from two tables. Table 1 (Oracle) was loaded from an Excel Spreadsheet and Table 2 was loaded from another Oracle table. The fields in both tables are defined as NUMBER. When they are imported into Datastage, I change them to Integer. This is probably where I am doing something wrong. They pr...

My metadata for the stream and reference links refer to Integer(10). When the lookup stage is executed, almost all records are rejected. I tried many numerical datatypes and could get the comparison to work. Once I changed the numeric value to a VARCHAR(10) and TrimB the value, the lookup stage work...

After numerous attempts to get the LOAD function working in Datastage, I want to know whether I am making the right decision in the way I load data. As my process is reloading from scratch everytime, I thought the LOAD/TRUNCATE was my best option. But, from what I have been told, it may not. I was t...

I insert a Dump_Score and got the following message: op37[2p] {(parallel inserted tsort operator {key={value=TIME_ID, subArgs={asc, nulls={value=first}}}, key={value=REGION_RCM_NUMBER, subArgs={asc, cs}}, key={value=SUB_ACT_CD, subArgs={asc, cs}}, key={value=PI_QUALIFIER_ID, subArgs={asc}}, key={val...

I searched the online manual and it was very vague on the partitioning requirements for the Aggregator Stage. I am working on a two node box and when the data reaches the aggregator stage, it aggregates the data on the two nodes and not as one. I end up with duplicate records and two different total...

I created a job that requires multiple links from a copy stage into multiple lookup stages. My question is, I really don't want to cross link lines in the design. It looks and will cause confusion. Is there a way to refer to stages without crossing lines. I can reuse the Oracle stage multiple times ...

I am going to do more tests and I will post the results.