DSXchange

A few points to troubleshoot 1. Ensure RCP isn't causing clashes. 2. If your dataset was created with a non-keyed partitioning method, ensure that you don't preserve partitioning while performing the join. Go ahead and do a hash partition and sort on the join keys. 3. Try to verify if the issue pers...

Not sure descriptor files that big are possible. A descriptor file contains the metadata and a copy of the configuration file.

No. The metadata for your flat files will be derived from the schema files that you will have to create and place in a location on your server.
The metadata for the target tables will be directly available to Information Server provided you supply the right credentials. This is how RCP works.

1. Create a single RCP job with your source, target and any intermediate generic transformations. 2. Create a looped master sequencer with a delimited string of your file name/schema file name/ table name triplets in the start loop stage. 3. Use a user variable activity to extract each value into th...

You can use the oracle connector within a parallel container in your server job

I used to think the same till I came across the below in an IBM redbook (Data flow and Design) The following guidelines should be followed when constructing parallel jobs in IBM InfoSphere DataStage Enterprise Edition: Never use Server Edition components (BASIC Transformer, Server Shared Containers)...

But why would you want to use a filter when you can achieve it with a parallel transformer? The transformer is more efficient than the filter

Assuming you have a reject link in the target connector, open the connector properties and click on the reject link in the graphic shown in the top left. The properties shown are probably what you are looking for.

Thank You Hoping that IBM fixes this bug(if I may term it that) in the future.

I don't seem to be able to view performance statistics within a local container. Am I missing a setting/property somewhere or is that how it is?

I created a job that looks something like below SK1 ROWGEN ----> SK2 -----> DS SK1 creates the state file while SK2 generates the values. If like you said, both flows are executed at the same time, shouldn't the job have aborted due to the absence of the state file? How is it that everytime I run, t...

Was just wondering if it is possible to have independent flows within the same parallel job. Something like SEQ --- TXN ----DS DS --- CP ----ORA Both these flows would be within the same job. I understand that this is possible but what would the order of execution be in such a case. Also, I would li...

rameshrr3 wrote:Can you edit row metadata ? There you can set null field value

No

Are you sure that an external filter stage has a format tab? Because I don't see it. Guess you confused it with a sequential file stage

Thank you. Alternatives provided at viewtopic.php?t=125243&highlight=removing+header were useful