DSXchange

The Length of P_ID in OCI stage is 38 and the data type is Decimal.There is no scale.

Its Decimal and length 60.

Hi all, In my target table,I've a column P_ID which is given by Measure/Rate ,Measure and Rate coming from the source table. The value getting into P_ID after the division is getting rounded off. For Eg., If the actual value after the division is 122.91,P_ID will get populated as 123, If the value i...

Hi there,

When trying to load from OCI stage to the Pivot,I am encountering an error ORA01002:fetch out of sequence, and the job get aborted.

I did c a similar post on the same topic,but the solution doesnt seem to work.

Any other solution?

Regards,
shilpa

Use sorted data for aggregator.

Try using bulk loader whereever possible

Sort the data in the table.

Metadata mismatches while writing into the table can b severe.Metadata mismatches can happen due to inordered columns or datatypes.

The best way to avoid this is to directly import it from manager.