top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: How can we eliminate duplicate rows from flatfile, please explain?

+1 vote
315 views
Informatica: How can we eliminate duplicate rows from flatfile, please explain?
posted Aug 18, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

using sorter transformation for distinct in a flat files

answer Aug 19, 2015 by Manikandan J
Similar Questions
+2 votes
delete duplicate rows using informatica

How can we delete duplicate rows from source database table using informatica. This has to be done without using any other table. Means source and target is same table in Oracle database.

0 votes
Truncate target Table based on rows in a Target Flatfile

I have a workflow which loads data from a Flat file to a Stage Table after a few basic checks on a few columns. In the mapping, each time my check fails (meaning if the column has an invalid value) , I make an entry to a ErrorFlatFile with an error text.

Now , I have two targets in my mapping. One being the Stage table and the other is the Error Flat File.

What i want to achieve is this ? Even if there is one entry in the ErrorFlatFile (indicating there is an error in the source file ) , I want to truncate the Target Stage Table.

Can someone Please help me with how i can do this at the session level.

...