DSXchange

HI,
My requirement is to update a COLUMN in oracle table from the value from netezza table. The job is running fine and updates the value with respective id.
If an id is not in my netezza table , the column was left as null value.

Now i need to update values if the id is present in source else need to set as zero..

Thanks in advance

I'm not clear on the mapping, but consider using Oracle left outer join to netezza and NullToZero(value from netezza).

truenorth wrote:I'm not clear on the mapping, but consider using Oracle left outer join to netezza and NullToZero(value from netezza).

lets consider Table Tab_A,
ID COL_A
1 199
2 299
3 399

Table Tab_B
ID COL_B
1 NULL
2 NULL
3 NULL
4 NULL
...

Need to update the table Tab_B from Tab_A,
Tab_B should be,
ID COL_B
1 199
2 299
3 399
4 000

Need to Update "0" to COL_B for the ID that is not present in the TAb_A...

Just as I thought.

Tab_B left outer join Tab_A on ID

followed by

Transformer, where Tab_B.COL_B is derived from NullToZero(Tab_A.COL_A)

Where the ID matches, Tab_B.COL_B gets the value from Tab_A. Otherwise, it gets zero.

If you're updating while data are in transit, use NullToZero() function.

If you need to update in the Oracle table, don't bother using DataStage - execute a simple UPDATE statement against the table.

How is this any kind of WORKAROUND? You are (or certainly should be) Resolved now.

I deployed two jobs,
One to update the Oracle table from Netezza Table
second to update null value to zero in Oracle table

I am working around with some more option..... to do it in one job

OK, your "two jobs" is a workaround of sorts but there is absolutely no need for two jobs to do something so simple.