Left outer join in HASH file

[chulett]

We are obviously missing something or you've left out some critical details - this is dead simple and should work as desired and as (allegedly) designed... unless you are not telling us everything.

[karthi_gana]

Your steps 1 through 3 can be summarised as "get ALL the records".

get all the records with prtf_id (if fnd_id matches otherwise simply place NULL in prtf_id column)

[chulett]

Again, for the umpteenth time, your design as posted will do exactly that. What are we missing?

What exact 8.x version are you running, btw? If it is anything other than the latest iteration of 8.1.x.x then suggest you check with your official support provider and see if this is a known bug in your platform's version.

[arunkumarmm]

Er, you're trying to put NULL into a sequential file? Good luck.

Why do you think it will not accept NULL. Seq file will accept NULL.

[ArndW]

I'll side with Craig on the NULL in sequential files question. Try writing a null to a sequential file in DataStage and then reading the null.

[kris007]

Why do you think it will not accept NULL. Seq file will accept NULL.

Unless you specify a default for NullFieldValues within the Sequential file stage properties you will have trouble reading NULL's.

[chulett]

Not in a Server job.

[arunpramanik]

Unless you specify a default for NullFieldValues within the Sequential file stage properties you will have trouble reading NULL's.

I don't think so, if the field is set as Nullable = Yes, the NULL will be stored with nothing separated by the field delimiter (,) with the default setting something like
"ABC",,90.00
Certainly you can read the same out from sequential file with same default setting