Oracle Connector Stage and Oracle Enterprise Satge

1. What is the difference between Oracle connector stage and Oracle enterprise stage.
2. If we can achieve Oracle enterprise stages task using Oracle connector stage then why Oracle enterprise stage exists?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 3 of 3 Answers


  • Aug 24th, 2016

Oracle Enterprise
1) It supports one input or one output and it supports a reject link at target side
2) It doesn’t show the Test Connection
3) Less Performance compared to Oracle Connector
4) Time taking is more

Oracle Connector
1) It supports one input or one output and it supports N no. of reject links at both the sides
2) It shows the Test connection
3) More Performance compared to Oracle Enterprise
4) Time taking is less


  • Aug 24th, 2016

2) Ans: min of 3 stage variables are required according to my view.
example: if the source has two columns cid, address. we want to remove the duplicates in cid, our job design follows like below
in sort stage: select key=cid
under options> select key change mode = true then it will generate group id.
transformer stage : create 3 stagevariables like s1, s2, s3
s2= if s1<>s3 then 1 else 0
s3= cid
in output derivation write contraints for two outputs
1output= s2=1 for unique records
2nd output=s2=0 for duplicate records

  Was this answer useful?  Yes


  • Feb 3rd, 2017

Oracle connector having test connection. Ie plugin which is not Present in the enterprise state

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions