I have two tables
Recharge_Details
SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER.
First_Rechrge
SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER.
Compare the Recharge_Details SUBSCRIBER_ID with
first_recharge table SUBSCRIBER_ID (at initial level First_Recharge
table is blank) , if SUBSCRIBER_ID
already present in First recharge table ignore else insert SUBSCRIBER_ID into First_recharge table
I need to capture first recharge of SUBSCRIBER_ID...
How to find First recharge?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have a couple of choices, effectively the same logically.
Perform a lookup against first recharge table with Lookup Failed rule set to Continue, then test in a downstream Transformer stage whether the columns returned from the reference input are NULL.
Or perform a left outer join, with recharge details as the left input, then process similarly in a downstream Transformer stage.
Getting a premium membership would be good, too.
Perform a lookup against first recharge table with Lookup Failed rule set to Continue, then test in a downstream Transformer stage whether the columns returned from the reference input are NULL.
Or perform a left outer join, with recharge details as the left input, then process similarly in a downstream Transformer stage.
Getting a premium membership would be good, too.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
I have written query in oracle connector
SELECT SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER FROM Recharge_Details ORDER BY RECHARGE_DATE_TIME;
After that i have taken remove duplicate stage .In Removeduplicate stage key = SUBSCRIBER_ID
Duplicate to Retain = First.
Can you suggest me above process is correct or not?
I have written query in oracle connector
SELECT SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER FROM Recharge_Details ORDER BY RECHARGE_DATE_TIME;
After that i have taken remove duplicate stage .In Removeduplicate stage key = SUBSCRIBER_ID
Duplicate to Retain = First.
Can you suggest me above process is correct or not?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes and no. According to the specification in your original post you also have to undertake some kind of checking/processing against the FIRST_RECHARGE table. Your more recent post on this thread seems to omit this requirement altogether.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Can you suggest us if above process seemed to work or not?pkll wrote:Can you suggest me above process is correct or not?
Last edited by chulett on Sat Apr 20, 2013 6:44 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers