Hi,
I am using Dyanamic RDBMS as my source and target.
How to remove the duplicates in the DYNAMIC RDBMS stage in source.
I am using the lookup in the job. I want to restrict the duplicates either in the source(Dynamic RDBMS) or in lookup stage.
Will any one please help me out.
Thanks for the help.
Dyanamic RDBMS
Moderators: chulett, rschirm, roy
Dyanamic RDBMS
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
Re: Dyanamic RDBMS
hello,
in your Dynamic_RDBMS stage use "User-defined SQL" and write a sql statement like
'Select distinct column_name from your_table_name", with proper column mapping with your sql statment.
it works fine eliminating duplicate records, just try.
in your Dynamic_RDBMS stage use "User-defined SQL" and write a sql statement like
'Select distinct column_name from your_table_name", with proper column mapping with your sql statment.
it works fine eliminating duplicate records, just try.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: