How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 20489 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
Explain the scenario which compels informatica server to reject files?
what is the size of your data warehousing?
Why union transformation is an active transformation?
Design time, run time. If you don't create parameter what will happen
Define update strategy?
Explain lookup transformation in informatica
Enlist some properties of sessions.
What is different between the data warehouse and data mart?
What are the new features of informatica 9.x at the developer level?
Can you use flat files in Mapplets.
How to extract the informatica rejected data?
how we can load rejected record's at run time?(not through bad files)
How to update source definition?
What is substr in informatica?
State the differences between sql override and lookup override?
