DSXchange

Hi, I think, you have to check your flow once again.Any where, by mistakenly you have different nullability of field TIME_KEY from source to target. The warning saying that, handle those null, its suggesting that use modify stage for this purpose.Check the your source data also for the field TIME_KE...

Processing is already happening in parallel in my 8 nodes, am looking forward to do the extraction of records in parallel. Considerable amount of time could be saved if i could do the extraction of records on multiple nodes. Also the fact that the no of records fetched by the db2 stage in parallel ...

Hi, Few more points, I have missed from my last post. If you are intended to use DB2 API stage. Use execution mode is Sequential only and set your parallel configuration file for 8 nodes. While extracting the data it will take in sequentail manner from DB2 API stage and while processing the data it ...

Hi, Some time back, I have done some testing with DB2 API stage. When you will change the execurion mode from sequentail to Parallel. It will take the Entire partition as Auto partition. So, you will get Numberofnodes * Number of records as a result. Each node will take entire data. This is due to A...

Hi Peter, Rather than creating dummy column and perofrm inner join. You, can do one thing, which is already suggested by ray. Rename the column name that should be same in the both the datastes. Use copy stage to rename the columns. For example, you have a key with the name 'Amount' in one dataset a...

Hi, These are all because of resource allocation to the jobs for monitoring the data. We have environmental variables called APT_MONITOR_SIZE and APT_MONITOR_TIME. These variables will lead the monitoring functionality in Data Stage. overridden the default setting with values, set APT_MONITOR_SIZE a...

Hi, If a job running continously in a environment, we have to perofrm kill operation by using PID of the same. We can perform this by using DataStage director, Cleanup resources operation. Where you will get PID of your job and perform Stop operaion their. it will stop your job from running continou...

Hi, Few more points about Hash/ sort mode option in the Aggregator. Hash Mode : you should hash partition the input data set by one or more of the grouping key columns so that all the records in the same group are in the same partition (this happens automatically if auto is set in the Partitioning t...

where can we find the option to enable/disable RCP i dont find in CDC stage can any one please help me out Thanks Hi, You can find the Run time column propogation at the stage level also, In Change Capture stage-go to the output tab and then go to the Columns tab, in that tab see below the cloumns ...

Raftsman wrote:Thank you very much...I can't tell you how much this has frustrated me. Thank god for this forum..

Hi,

Its nice to hear that your problem was resolved. But, mark it this post as RESOLVED and it will be nice.

Hi Peter,

Just try out this, it may helpful for you. Change the output datatype of every column in the aggregator to Double and in the down stream once again changed to decimal in any other operator.Its working finely for me.

Hi,

Disable RCP option at the job level in the property tab. Where you can find option called Enable runtime column propogation for new links. Don't select that option that means nothing but Disabled.

And the problem is you don't get a clue from Oracle which field is the problem... you get to figure that out all on your lonesome. :roll: Hi, This is purely data problem. As craig suggested, you have to dig yourself into the data, there is no choice to identify it. Just check the 1638 row for all t...

hi all - The mode of operation was already set to sort.. - How/where do I specify that the data is already sorted. Cant find the option in the aggregator? Peter Hi, You can't find that option in the Aggregator. You can find the same in the sort stage to identify the sorted data. If the Data is sort...

BalageBaju wrote:Hi Ramu,

What is the error message its throwing?

Balaji

Hi,

I think ramu's problem is, he is not able to compile his job. you may need to check your C ++ installation in your server. Transformer stage is driven by C ++ code only.