Page 2 of 2
Posted: Thu Jul 22, 2010 5:26 am
by 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.
Posted: Thu Jul 22, 2010 6:53 am
by karthi_gana
ray.wurlod wrote: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)
Posted: Thu Jul 22, 2010 7:41 am
by 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.
Posted: Wed Jul 28, 2010 12:29 pm
by arunkumarmm
battaliou wrote: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.
Posted: Thu Jul 29, 2010 5:55 am
by 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.
Posted: Thu Jul 29, 2010 6:30 am
by kris007
arunkumarmm wrote:
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.
Posted: Thu Jul 29, 2010 7:48 am
by chulett
Not in a Server job.
Posted: Thu Jul 29, 2010 8:16 am
by arunpramanik
kris007 wrote:
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