I am facing problem while using Column of datatype in source Query of Oracle. I Googled the same and found we cannot use UNION incase of CLOB while we can use UNION ALL, but by using UNION All we will get duplicates. We cannot apply distinct on CLOB column. Is there any way we can do union of CLOB columns in DataStage and get the distinct value. Apart from clob column there are other columns in source Query. When we remove Clob Cloumn from source , our Union Query works fine.
Regards,
Pacific
UNION of CLOB in DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 35
- Joined: Wed Oct 06, 2010 11:24 am
I assume you can use 2 seperate queries and combine them with a funnel , parse the clob data and remove duplicates from resolved fields if that was ever an option. I really do not know at this moment if you can set the entire clob data column as a key for removing duplicates though . Was the CLOB data plain text or a wellformed XML ?