DSXchange

No Ray, Key_Col is not a join key field. Applied hash partition based on key column, giving sorting, case sensitive, perform nulls first. Still same problem exist.. AM not understanding y it is working in dev. environment but not in TEST env. what might be the reasons Will it be a environment issue....

Even I am facing the same problem in Test Environment. Only change is my job uses Inner join. Though data is matching.. join is not capturing data and target dataset is not created.

Kindly post ur suggestions

Thanks,
Rachitha

As DS1 and DS2 is left outer join. The column coming from DS2 i.e Key_Col is giving null value. Though matching data exists, Key_Col is populating with NULL value which is wrong.

Thanks,
Rachitha

hi Narayana

Welcome aboard
What is the source and give the details of what validation you want to do.

For each input record we are getting four warnings in director as mentioned below: 1.Violation of PRIMARY KEY constraint 'PK_LU_COMMODITY_SUB_CLASS'. Cannot insert duplicate key in object 'LU_COMMODITY_SUB_CLASS'. 2.The statement has been terminated. 3.Job_Dim_Commodity_Sub_Class..Xfm_ST_F0005_Lu_Co...

Hi,

<outputlink.LASTERR> works with DRS Stage. But we are getting message as "Row Rejected" for all failure cases like primary key violation, datatype mismatch,null value rejection,etc.

Please let me know how to get appropriate error message.

Thanks,
Rachitha

Hi,

I am using DRS Stage as target in my job. Am not able to get DBMS code for rejected rows using <linkname.DBMSCODE>.

If target is ODBC Stage then its returning DBMS Code.Please let me know how to get DBMSCODE for DRS Stage.

FYI: Our requirement is to use DRS Stage.

Thanks,
Rachitha.

Sheema,

Give Constraint as <outputlink.rejected> for Rejected Rows link.
And make sure in source you have given filter condition.

Thanks,
Rachitha.

Update Action: Clear the table, then insert rows

Will this work?

Thanks. Now i see that Replace Existing rows completely does not serve my purpose.For example if i have 3 rows as below already existing in the Oracle table 1001,abc 1001,def 1001,rst where as i have below 2 rows in the source file 1001,abc 1001,def I should design a job where i should just have th...

On average I have more or less the same row/s but time to time the loading time can be impacted by the server capacity and ressource availability. Most of the time I copy first source data from db into flatfiles, this speed up the the data mapping with hashfiles. (and I do read only what I need, no...

Try for this

write a routine

$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle = DSAttachJob(Arg1,DSJ.ERRFATAL)
Ans = JobHandle

run this by giving Arg1 as the job name (job1)
If it returns 0 then there is some problem with the job.

Thank you ,
Rachitha.

Hi,

First check whether job1 is existing,
Second check whether you have given correct job properties in respective job activity.

Thank You,
Rachitha.

HI I am struck in the rates table now. The problem is : I am doing a lookup on saome keys like year and period. If the Currency_Code is not USD in the main table and lets say it is EUR, now I have to do lookup on the rates table for the conversion rate to USD. Main table: Curency_Code, Amount, Amou...

Hi

We cannot do any sort operation in hash files only way is to use sort stage.If your src in ODBC stage then add ORDER by in your query.But you can apply any filter conditions in Hash file Stage: output->selection "here you can specify filter condition".

Thanks,
Rachitha.