vibgyss

• 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

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