Funnel Stage Output is incorrect
Posted: Thu Nov 22, 2018 7:41 am
Hi All
I have a DS Parallel job in (DS 11.7.1) with 3 Sequential file stage,3 Transformation Stage,1 Funnel and Output to a Dataset.
3 Sequential file has different layout. But using Transformation stage we got all Fields into one layout. Then sending those 3 outputs to Funnel. But the Funnel output is giving incorrect output for few Records but few records output looks correct.
Output from Transformer stage :
Key : 101 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Key : 102 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Output from Funnel stage :
Key : 101 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Key : 102 Date1:NULL Date2:NULL Date3:NULL
Can you please let me know where could be the issue.
I have a DS Parallel job in (DS 11.7.1) with 3 Sequential file stage,3 Transformation Stage,1 Funnel and Output to a Dataset.
3 Sequential file has different layout. But using Transformation stage we got all Fields into one layout. Then sending those 3 outputs to Funnel. But the Funnel output is giving incorrect output for few Records but few records output looks correct.
Output from Transformer stage :
Key : 101 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Key : 102 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Output from Funnel stage :
Key : 101 Date1:2018-10-31 Date2:2018-10-31 Date3:2018-10-31
Key : 102 Date1:NULL Date2:NULL Date3:NULL
Can you please let me know where could be the issue.