How to delete duplicate rows in flat files source is any option in Informatica ?
How to delete duplicate rows in flat files source is any option in Informatica ?
1) If source is file, then
--a) Unix command-based function during pre-processing.
--b) Utilize Aggregator transformation without aggregate function.
2) If source is relational table, then
--a) Use Distinct key word in Sql Override in SQ.
--b) Utilize Aggregator transformation without aggregate functio
There are currently 1 users browsing this thread. (0 members and 1 guests)