DSXchange

Thanks Ray.

Just tried it after your reply. It worked!

Hi,

Is it possible to reference to a column in the DataStage metadata using ORCHESTRATE.column_name in a SQL file containing an insert statement in a target oracle connector stage?

I dont have any partition on the input flows of the join Why? I use the Balanced Optimization Tool to improve the performance in this job Is it possible that executing a simple "SELECT * FROM TABLE1 left join SELECT * FROM TABLE2" between this two large tables is faster than the same oper...

Are you saying that your file could look like this ?
or like this?

Operator of type "APT_JoinSubOperatorNC": will partition despite the preserve-partitioning flag on the data set on input port 0. buffer(3): When checking operator: Operator of type "APT_BufferOperator": will partition despite the preserve-partitioning flag on the data set on inp...

Hi, I am faced with a situation where we may need to vertically pivot data from rows to columns but do not know for sure exactly how many columns it will need to be pivoted to. We do have an upper limit but the limit is 100 and the probability of getting more than 8-12 columns is very less. We want ...

Wouldn't 'SET' try to force the next stage to preserve partitioning, thereby producing the same warning again? I've set the flag to 'CLEAR' to ensure that the stage is impervious to the partitioning of downstream stages

All the stages upstream of the lookup, yes.

And here's the output of APT_DUMP_SCORE main_program: This step has 30 datasets: ds0: {op0[1p] (parallel APT_CombinedOperatorController(0):APT_TransformOperatorImplV0S13_NestedTableEDI852_Delimted_Transformer_13 in Transformer_13) eOther(APT_HashPartitioner { key={ value=MasterKey, subArgs={ cs } } ...

Changed lookup to join and receiving a warning on similar lines Operator of type "APT_JoinSubOperatorNC": will partition despite the preserve-partitioning flag on the data set on input port 0. buffer(3): When checking operator: Operator of type "APT_BufferOperator": will partitio...

Hi, My lookup is throwing the warning Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. I have set the preserver partitioning flag on both the stream as well as the reference links to 'clear' but I continue to receive...

Hi Ray,

I'm on DataStage 8.1 and I don't think the Oracle connector will accept multiple inputs.

We have a source file that contains hierarchical data. I'm using a DataStage jbo to separate the parent from the children and the grand children into 3 different links. The target is an Oracle table with the children going into nested tables within the parent table. What would be the best way to seq...

I agree. I don't see the need for a look-up here. A column generator will suffice

I wasn't able to use the DT stage due to lack of sufficient knowledge. But I managed to implement it using a sequence of oracle connectors with the parent/child approach. Thank you for your timely assistance.