DSXchange

ray.wurlod wrote:Yes it does. ...

Ray, if a file has records with different layout, can this file be processed using a CFF ??

DSguru2B wrote:

ray.wurlod wrote:Comparing the two DSX files with diff does show you what's changed.

You read my mind. But ftp'ing the files every time is a pain.

You both mean comparing two .dsx with diff option using UltraCompare ??!! Clarify Pls. Thanks

ray.wurlod wrote:Planning and Peer Review
Before you even touch DataStage, sketch out your plan of attack. Which stage types will you use, and why. Sources and targets - are their table definitions in Reposi ...

thanks Ray..It helps.
Any other suggestions/best practices are welcome and appreciated.

Hi, Most companies use DS for DataWarehousing etc and we are using it for our Application Developement. DS is a new product in our place and ours is the first group to be tried out. We are in the learning curve and in the short time, have grasped the tools' capabilities/power etc, and at the same no...

Supposed to be that functionality in 8.x but for now I still do it the Old Fashioned Way: two dsx exports and a good compare utility, like Ultra Compare for example. ... Thanks chulett for guiding towards UltraCompare. Would give it a try. For now, we have no means to do know what has changed from ...

being new to DS we had a bunch of very expensive IBM consultants recommend how to structure our jobs. In general we found them very helpful. one area in which they were quite adament was in us NOT landing the data (notwithstanding restart considerations) for performance reasons. This dictated very ...

Hi, Please help me out with Version Control. As per IBM,DS-VC isn't that helpful, and most of them use PVCS/VSS etc for Version Control. How do you guyz do at your shop? Also If a team member has made a change in a Job, how would another member know what EXACT change the other person has made. Is th...

I would first try to build it using a lookup table, though this depends on whether the equation fits a lookup table design. Second I would try stage variable code which works well for up to three lines of code per stage variable but is stretched beyond that. Third is probably external routine so yo...

Helpful article: Is DS Parallel Transformer Evil? Vincent quotes " Over my years of using parallel jobs I haven't noticed that much of an overhead and when you use the transformer for several tasks (transform, filter and copy) it can be faster. " Exactly...Until the Parallel Transformer, ...

If you are on v7.5.1a or above, I'd personally go for single Transformer stage rather than using Modify plus Filter. Yes I would second that. We had few Filters in our application because we felt Filter fits in the role, but the IBM experts suggested otherwise. [to use a Parallel Transformer instea...

Hi, We started using Pivot [though not in parallel mode] and was advised to go for build-ops, which would be better in performance. But of late, realised that Pivot Stage can be used in Parallel mode and it looks like the performance is in par with that and infact slightly better than that of build-...

Hi I am facing this below warning message. FF_LYHIER,0: Input buffer overrun at field "Field015", at offset: 52 Please some give a suggetion. regards konda If your input data doesn't exactly match with the table definition, you will face this. Make sure the table definition matches with i...

DSguru2B wrote:Call , You mean use. Yes, by surrounding them with hashes (#). ...

So if CNY is a Job Parameter defined, then should I use #CNY# to refer to this job parameter value in the Transformer ???

ray.wurlod wrote:Or, if there's some reason not to sort by GK4 and GK5 up front (for example you may not have them until you've performed a lookup or join) then Option 2 is definitiely to be preferred - but you MUST p ...

Thanks Ray..I'm going to go with Option2

Good suggestion chullett . I guess that is more appropriate in his case. He can use this approach in case all records rejected are not getting processed . I prefer the other approach since i need to process some of the records which are also rejected , so that we can report those as data which has ...