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?
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
vibgyss
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
seqfile-sort-transformer-target
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
s1=cid
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
Siva
Feb 3rd, 2017
Oracle connector having test connection. Ie plugin which is not Present in the enterprise state
Oracle Connector Stage and Oracle Enterprise Satge
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
Related Answered Questions
Related Open Questions