DSXchange

All 7 outputs are selected and linked to datasets

Hi all, I am trying to work out an example of 2 source matching (multiple-to-one multiple). In the source data set i have created 2 rows with exactly the same values for all columns. I have also created 2 matching rows in the reference data set. After the job is run, both rows in the source data set...

HI all, Got an error message "Parallel job reports failure (code 13)" in a production job. Never seen it before in lower environment. The server version is 8.5. I did a search couldn't find what code 13 means. Does any one know? There are no other error messages. The data source is Sybase ...

We have to run a job with xml stage with pretty large input file size. The job works in production environment. Once we get it into dev project it fails. We suspect we need to increase the memory heap size in xml stage because that is one of the differences we see. However inside the xml stage, it d...

Hi, Search the forum for CDC topics. That should give you more information on how to handle SCDs as well as to generate SKs. HTH --Rich I don't have a problem using CDC or SK. My question is that if the new SDC stage is rigorous enough for us to throw some heavy stuff at it. The new SCD stage centa...

Our company is getting version 8 very soon, and is considering implement type 2 SCD using SCD stage. I have read SCD stage use in-memory lookup. If we have a monster-type SCD type 2, (I have talking about potentially hundreds of millions rows with at least dozens of type-2 columns), is SCD stage sti...

You can try to preprocess it if it is a unix flat file using sed. Here is one I stole and modified. Save it in a file and do: sed -f mySedFile input.dat > output.dat Basicly, it searches and loops for lines that are not ended with "}" + possible trailing spaces, and removes the "\n&qu...

I need to do an update (conditional) and insert (unconditional) in order. I have 2 output links from a transformation stage, and specified the link order in the tranformation stage with update link before the insert link. However, it seems the ordering is not strictly enforced in PE. Sometimes the u...

I have question on what to set for partition method for lookup or join stage. If the main source is partitioned DB2 source, and I need to do lookups and join using separate stages, what partition method should I be using on the lookup/join stage? DB2, Auto, or Full? The reason I am asking is that af...