Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
nani0907
Participant
Posts: 155 Joined: Wed Apr 18, 2007 10:30 am
Post
by nani0907 » Fri Nov 21, 2008 4:44 am
Hi All,
how to capture unmatched records after doing reference with database .
could you please help this
Thanks in Adavance
thanks n regards
nani
mdbatra
Premium Member
Posts: 175 Joined: Wed Oct 22, 2008 10:01 am
Location: City of London
Post
by mdbatra » Fri Nov 21, 2008 5:03 am
1.Left/Right/Full Outer in Join.
2. Use Reject Link from lookup.
Rgds,
MB
nani0907
Participant
Posts: 155 Joined: Wed Apr 18, 2007 10:30 am
Post
by nani0907 » Fri Nov 21, 2008 5:55 am
Is there any option without going for reject link in lookup stage .
thanks n regards
nani
hamzaqk
Participant
Posts: 249 Joined: Tue Apr 17, 2007 5:50 am
Location: islamabad
Post
by hamzaqk » Fri Nov 21, 2008 5:57 am
only merge and lookup stage allow us to capture rejects
Teradata Certified Master V2R5
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Nov 21, 2008 10:05 am
Only the Merge stage consumes rows as they are selected from its Update input(s). You could devise a mechanism to discover what remains in the Data Set supplying the Update input.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nani0907
Participant
Posts: 155 Joined: Wed Apr 18, 2007 10:30 am
Post
by nani0907 » Sun Nov 23, 2008 10:45 pm
Thanks Ray.
i will try with that.
thanks n regards
nani
mdbatra
Premium Member
Posts: 175 Joined: Wed Oct 22, 2008 10:01 am
Location: City of London
Post
by mdbatra » Mon Nov 24, 2008 1:43 am
You want to capture unmacthed records from Primary(Input Data Set) or Secondary(Reference Data Set) ?
Rgds,
MB
snt_ds
Premium Member
Posts: 280 Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India
Post
by snt_ds » Mon Nov 24, 2008 1:46 am
I want to capture from Primary dataset(INPUT).
mdbatra
Premium Member
Posts: 175 Joined: Wed Oct 22, 2008 10:01 am
Location: City of London
Post
by mdbatra » Mon Nov 24, 2008 2:01 am
snt_ds.
for capturing from primary ,have to use look up stage.
Rgds,
MB
Shruthi
Participant
Posts: 74 Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore
Post
by Shruthi » Mon Nov 24, 2008 2:07 am
You can use joiner with join type as left outer join. Use left link as input.