How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 20024 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / harish konda
Give the SQL query to sort the data in source in source
qualifier t/f.
And then connect to exp t/f and add one more port (say flag)
to generete numbers like, when prev row and current row
values are same, then increment number, or else give 1.
And next connect to Filter t/f and give the condition in
filter as flag=1.
Then rout the data to target.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the function of aggregator transformation?
How do you change a non-reusable transformation to reusable transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is data transformation manager process?
How to do the error handling of if ur source is flatfiles?
What are the prerequisite tasks to achieve the session partition?
how many types of dimensions are available in informatica?
Differentiate between a repository server and a powerhouse?
What are the different transaction levels available in transaction control transformation?
How union transformation is used?
What is aggregator transformation in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is source qualifier transformation in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
