You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] problem with First Match records(in tMap)!
Post a reply
Topic review (newest first)
- beardoraemon
- 2012-10-26 18:23:29
i have same issue, everything runs perfectly, but when i change to first match, have java heap space issue. Any solutions?
- buzzy96
- 2012-05-24 12:33:11
any help on this post?
- buzzy96
- 2012-05-24 09:47:14
hi pedro,
could u pls see my i/p and o/p results in my first post?
- pedro
- 2012-05-24 09:44:29
Hi
Code:
how to get First Matching records from lookup table and need to update according the target table by using EmployeeID as a Key?
I think I misunderstand what you mean.
Could you explain it in another way?
Regards,
Pedro
- buzzy96
- 2012-05-24 09:41:58
by using that feature all records are updating!!!!,i already check.,not sure why tht function is not working perfectly???
pls let me know ,any another way ...
- pedro
- 2012-05-24 09:25:05
Hi
Use 'first match' feature of tMap as the following image.
Regards,
Pedro
- buzzy96
- 2012-05-24 09:06:50
hi,
i am updating existing table by using EmployeeID,here table having duplicate records of EmployeeID.
main table:-
employeeid
------------
101
102
103
lookuptable:-
employeeid
------------
102
102
103
103
103
105
105
expected output
-----------------
employeedid hc
------------- -----
102 1
102 0 or null (previously null before this load )
103 1
103 0 or null (previously null before this load )
103 0 or null (previously null before this load )
105 1
105 0 or null (previously null before this load )
how to get First Matching records from lookup table and need to update according the target table by using EmployeeID as a Key?
thx