Hi Manito,
How about a virtual table to represent the right table with the desired records to return only one when joining with the left table? Of course you would need to use regular SQL techniques to get the table as you want...
Another way will be to do the entire join in a virtual table
How to process/output only the first of multiple records
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Buenas dias, manito! Glad to be able to touch base here.
Thanks for your insight though. Always helpful to pick your brilliant mind.
On another note, are you guys still using IA? Or did you stick with Datastage for DQ?
Unfortunately, you're right...that table would have to be created outside of IA. I would have to involve other folks - DBA, IT infrastructure (they do IMAM, I don't). They do not have the bandwidth at the moment. I was hoping to use IA to pull this off.JRodriguez wrote:Hi Manito,
How about a virtual table to represent the right table with the desired records to return only one when joining with the left table? Of course you would need to use regular SQL techniques to get the table as you want...
Only possible in 11.5, which is currently being installed and won't be vetted until yearend. We're still in 11.3 which only allows for very basic SQL for VTs.JRodriguez wrote:Another way will be to do the entire join in a virtual table
Thanks for your insight though. Always helpful to pick your brilliant mind.
On another note, are you guys still using IA? Or did you stick with Datastage for DQ?
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
Sr Consultant, Data Quality
San Antonio TX