Error when loading Teradata Table
Posted: Tue Feb 07, 2006 4:06 pm
Hi,
I am trying to load a Teradata Table from Datastage PX job (Unix platform).
Job reads data from a Dataset (I am able to view data from Dataset)
Copy stage drops some column and changes column name and send the records to Teradata Enterprise Stage.
Teradata Enterprise stage is loading Teradata table in 'Append' mode.
I am using default Configuration file with 2 nodes ( no nodes mentioned for database).
Teradata table is not a partitioned table.
When I execute job With above configuration I am getting following error:
main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel Teradata_StrTransfer.
The number of partitions is already constrained to 10,
but an eSame partitioned input virtual dataset produced by
parallel Copy_45 has 2.
This step has 3 datasets:
ds0: {/home/vvxb1/Transfer_Details.ds
[pp] eSame=>eCollectAny
op0[2p] (parallel Data_Set_44)}
ds1: {op0[2p] (parallel Data_Set_44)
[pp] eSame#>eCollectAny
op1[2p] (parallel Copy_45)}
ds2: {op1[2p] (parallel Copy_45)
[pp] eSame#>eCollectAny
op2[10p] (parallel Teradata_StrTransfer)}
It has 3 operators:
op0[2p] {(parallel Data_Set_44)
}
op1[2p] {(parallel Copy_45)
}
op2[10p] {(parallel Teradata_StrTransfer)
}
Kindly let me know if you guys have any solution for this problem.
Thanks.
I am trying to load a Teradata Table from Datastage PX job (Unix platform).
Job reads data from a Dataset (I am able to view data from Dataset)
Copy stage drops some column and changes column name and send the records to Teradata Enterprise Stage.
Teradata Enterprise stage is loading Teradata table in 'Append' mode.
I am using default Configuration file with 2 nodes ( no nodes mentioned for database).
Teradata table is not a partitioned table.
When I execute job With above configuration I am getting following error:
main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel Teradata_StrTransfer.
The number of partitions is already constrained to 10,
but an eSame partitioned input virtual dataset produced by
parallel Copy_45 has 2.
This step has 3 datasets:
ds0: {/home/vvxb1/Transfer_Details.ds
[pp] eSame=>eCollectAny
op0[2p] (parallel Data_Set_44)}
ds1: {op0[2p] (parallel Data_Set_44)
[pp] eSame#>eCollectAny
op1[2p] (parallel Copy_45)}
ds2: {op1[2p] (parallel Copy_45)
[pp] eSame#>eCollectAny
op2[10p] (parallel Teradata_StrTransfer)}
It has 3 operators:
op0[2p] {(parallel Data_Set_44)
}
op1[2p] {(parallel Copy_45)
}
op2[10p] {(parallel Teradata_StrTransfer)
}
Kindly let me know if you guys have any solution for this problem.
Thanks.