Oracle table - Hash partitioned.
Posted: Wed Dec 12, 2012 3:43 pm
Hi All,
We are having Target oracle tables as hash partitioned.
When using oracle connector can we read tables in parallel ?
When i tried "oracle connector type" partition is used, its throwing out warning cant write and its performing sequential write.
Also , i see "hash partition type" in oracle connector stage, can we use this partition to load parallel ?
Also, instead if i use odbc connector as target does it do parallel write for hash partitioned tables ?
Thank you.
We are having Target oracle tables as hash partitioned.
When using oracle connector can we read tables in parallel ?
When i tried "oracle connector type" partition is used, its throwing out warning cant write and its performing sequential write.
Also , i see "hash partition type" in oracle connector stage, can we use this partition to load parallel ?
Also, instead if i use odbc connector as target does it do parallel write for hash partitioned tables ?
Thank you.