DSXchange

IS the (source,change) OR reference data(before) and target the same object ( FILE or Database table ) ? Combining operators will create circularity because of references within a single process , disabling combination shoudl ideally allow process isolation. That could explain what you see. Why don'...

Yes , I countinued with the 'workaround' I have ( The modify stage trimming made it look inelegant to me ) . But i think the variable length vector can be padded ( or defined in column metadata) to a fixed length that will be all inclusive . The split vector stage will require a fixed length vector ...

Sorry for replying to such an old post . But I've verified if you define the nested level columns ( level 02 columns of sub rec) in the combine subrecords stage , it works perfectly , and would be pretty useful to do vertical pivoting in conjunction with a column export stage - especially with older...

I have a data in which one column is a vector data looks like this [^X 2 4 22 22 19 8 ] ^X is the vector length prefix ( 1 bytes) the rest are elements of the vector. Is there any way i can convert the output to a delimited string array ? Output should be like '2'|'4'|'22'|'22'|'19'|'8'| I could do ...

Is it because a routine activity ( unlike a job activity) cannot be invoked as multiple instance ?

Bear in mind XML data itself may be sourced and written to many differnt types of data sources. I've worked with XML files, XML data columns in database tables( DB2, Oracle) and XML data that is read or written to a Message ( MQ) . There can even be custom programs that spew XML data to your datasta...

Can you affort to rewrite only the performance intensive and resource limited server jobs - after analyzing how each job would translate into its parallel counterpart? That is the best approach for the short term. IMHO Its a waste of corporate IT finance to convert ALL server jobs to PX - though tha...

Im just curios to knwo if there is any 'lookup*' specification in Modify stage that allows a developer to do a string to string decode . I 've used some lookup specifications that allow you to translate Integers to Strings and vice versa , but is it possible to translate one string value to another ...

Anyways , Im also thinking that Metadata workbench is not necessary - the install screen did not show any requirement in the engine or repository tier - Im doing the client side install and will keep you posted.

Can I use IIS Metadata Asset manager even If I do not have Metadata Workbench installed? The topology diagram for this application does not specify a Metadata work bench installation. Is it just a client ( Asset manager , Bridges and connectors) that works off the Websphere Application Server and XM...

Im new to IBM Information Server Manager. What version control tools can be used with IS Manager ? Does it have its native versioning facility or does it need to be integrated to an existing CVS repository ? Does anyone have success stories using this ? With Datastage Version 7.51 we had the standar...

Yes I remember seeing that the Difference stage was deprecated - But I have been seeing that in the docs ever since we had version 8. Im using v 8.7 now - and I can still the Difference stage ( as well as Compare stage - which by the way is giving me an error - Off to search i go )

I need some good reference for the comparison between Difference Stage and Change Capture stage in terms of performance & features. The only difference I could see so far was the requirement of pre sorted inputs to Difference stage ( and less important is the different integer values for the cha...

It works - We've used it in a transformer to call some unix commands .

You can also use external source stage

Command/Program : Read this into a single long varchar field and parse it with a column Import stage or Transformer with Field() function .