Funnel Stage
Posted: Wed Apr 28, 2010 6:05 pm
Hi,
I am having 2 datasets.
In one of my job i am using funnel to merge the data of the two datasets.
My design is
DS----->Xfm----->
Funnel ---------->Remove Dup --------->Oracle
DS----->Xfm----->
When I try to run the job the funnel is taking a long time to pass the data from XFM to Remove Dup.
I can see the 2 million records before the funnel and I used continuos funnel.
I dont know why it is very slow.
Can anybody help me out.
Thanks,
I am having 2 datasets.
In one of my job i am using funnel to merge the data of the two datasets.
My design is
DS----->Xfm----->
Funnel ---------->Remove Dup --------->Oracle
DS----->Xfm----->
When I try to run the job the funnel is taking a long time to pass the data from XFM to Remove Dup.
I can see the 2 million records before the funnel and I used continuos funnel.
I dont know why it is very slow.
Can anybody help me out.
Thanks,