Data Not Passing through Transformer
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Data Not Passing through Transformer
Hi,
The parallel job is not letting any data pass through the transformer.
There are not constraints.
There are no warnings in the director.
I am completely lost.
I read a post here regarding transformer issue between 8.5 and 9.1.
But I am designing on 8.5 and running on 8.5 too.
Regards,
Samyam
The parallel job is not letting any data pass through the transformer.
There are not constraints.
There are no warnings in the director.
I am completely lost.
I read a post here regarding transformer issue between 8.5 and 9.1.
But I am designing on 8.5 and running on 8.5 too.
Regards,
Samyam
Cheers,
Samyam
Samyam
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Are you sure the lines are not written to your output file? Sometimes DataStage removes some useless stages while running.
Because the link is believed useless the performance stats are not written under it, but they are actually drag to the output.
Because the link is believed useless the performance stats are not written under it, but they are actually drag to the output.
Last edited by Thomas.B on Fri Apr 08, 2016 10:40 am, edited 1 time in total.
BI Consultant
DSXConsult
DSXConsult
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
I believe the best help you can provide is to post the Director messages for the job. I would guess you have warnings that might help explain this.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
I'm going to guess you have a metadata issue between the DB2 data and the flat file and they are being 'rejected' by the target stage. You might want to change the Reject Mode on it to something other than the default of 'Continue' and see if that helps shed some light.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Hi,
yes it turned out to be a metadata issue.
specifically turned out to be NULL handling capability in the transformer.
Once we added the NULL handling function the code worked as expected.
The only surprising thing about this whole episode is there are no warning on the director.
Regards,
Samyam
yes it turned out to be a metadata issue.
specifically turned out to be NULL handling capability in the transformer.
Once we added the NULL handling function the code worked as expected.
The only surprising thing about this whole episode is there are no warning on the director.
Regards,
Samyam
Cheers,
Samyam
Samyam
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto