I am getting null values? Suggestion please

bond88 · Post by **bond88** » Thu Jan 03, 2013 5:39 pm

I have a job which has 3 joins, job is Oracle,Oracle --> Join, Oracle --> join, oracle --> join --> sequential file/Oracle table. At each oracle connector I am able to see data and while I ran the job it went successfully and it was showing as 74240 rows wrote in sequential file. But all the values are null only. First I thought it would be my mistake in join stage thats why I developed a new job but still getting null values.

chulett · Post by **chulett** » Thu Jan 03, 2013 5:45 pm

What kind of joins are you doing - inner? Left/right/full outer?

bond88 · Post by **bond88** » Thu Jan 03, 2013 5:47 pm

All joins are left outer and I used some more joins in oracle connectors as well (in queries).

bond88 · Post by **bond88** » Thu Jan 03, 2013 6:02 pm

I restarted my Datastage server. Problem Solved...