Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7797 Views
- I also Faced
- E-Mail Answers
Answer Posted / jakka
Below are the ways to eliminate the duplicate records:
1.Select distinct in source qualifier
2.Based on your requirement,select and give number of
sorted ports in source qualifier and need to override the
query using order by cluase. Then use aggregator and select
sorted input as given and use group by ports
3. Use sorter to sort data and then use aggregator as
mentined in point 2.
4.Use sorter to sort data and check distinct in soter
properties.
Hope this will help you...
Jakka
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Define slowly changing dimensions (SCD)?
What are the different etl testing categories as per their function?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how do u really know that paging to disk is happening while u are using a lookup transform?
Difference between flat files and relational sources?
What is grain of fact?
What is abap? What are idocs?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is the main role of FI on business
What is a mapping, session, worklet, workflow, mapplet?
Is hadoop a etl tool?
What is full load & incremental or refresh load?
How many steps etl contains?
