DSXchange

I need help regarding group ditermination. My input looks like this. the first 3 columns are my key. 10,20,30,A 10,20,30,X 10,20,40,B 10,20,50,Y 10,20,50,Z 10,20,60,D My output need to be 1st o/p : 10,20,30,A 10,20,30,X 10,20,50,Y 10,20,50,Z 2nd o/p 10,20,40,B 10,20,60,D I can do this by using the c...

Hi Felix,

It doesnt work. I think record count only matters when it is immediae mode.

thanks

Do we have any property in Teradata CONNECTOR to Roll back the mload transactions, if there is a partial load

Maintaining reference dataset is a very good point . Thank you very much Ray.

I got the below error , when combining two sources of customers ,

two customer data sets I made to one using funnel size . i renamed column name in both the links but forgot to change the legths.

i chaged the lengths to have same in both the links then this issue resolved.

Have a lookup on the first set where STATUS='Removed' with the second set, if you find any record then PASS this records to an Sequential Stage which would be your STATUS=IMPLEMENTED records and wherever you won't find PASS them to a Reject Link which would be your STATUS=REMOVED records Transformer...

In the transformer separate two types of records using constraint
1) Status = Removed
2) Status = Implemented

Then use Remove Duplicate Stage and pull either first/last record

Can you try using Unicode across your job

how to do that parallelisam in Datastage for oracle plugin in v8.0.1

yup Chulett, Tables has been partioned and I am reading from single partition. but I am using parallel degree concept and trying to read prallel. SELECT /*+ PARALLEL(gl.tgltran, 35) */ CACCOUNT, EFFDATE, ENTITY, AU, APPLICATION_ID, SOURCE_ID, TXN_AMT, DEBIT_CREDIT, SERIAL_NUMBER, WORK_DATE, BATCH_NU...

yeah, partition table property has been set and given table name there.

I am using datastage 8.0.1 and it doesn't have oracle connector stage.

Is there any other way to implement parallel concept here.

if you see below log from director, it says it's using 4 nodes main_program: This step has 1 dataset: ds0: {op0[4p] (parallel GL001P) => /opt/IBM/data/drm_fy_datamart/temp/GL001P.ds} It has 1 operator: op0[4p] {(parallel GL001P) on nodes ( node1[op0,p0] node2[op0,p1] node3[op0,p2] node4[op0,p3] )} I...

Thanks for your response Ray. how to program in stage to utilise 4 node configuration while reading data from oracle table partition, Ray- are you trying to say though datastage has 4 node configuration but orace EE stage can't utilise parallelisam and it will read data with only one node. Does it m...

actually I am reading data from only one partition by using where caluse.

and I have used parallel degree concept in select query but here it should share load across nodes right.

How can I make data shared between all 4 nodes to improve performance