Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7931 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
what is session partitioning?
What is abap? What are idocs?
What are the different etl testing categories as per their function?
how do u extract data from different data sources explain with an example?
What is partitioning? Explain about round-robin, hash partitioning.
how do use session mapping parameters ?(in which transformation)
what is pmrep command?
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?
SCD2 will work on only dimension tables as well as fact Table?
what is granularity in Data ware House?
Explain and compare etl & manual development?
what is the difference steps for data modeling?
how many maximum session supports to multiload in teradata ??
What is the difference between round-robin partitioning and hash partitioning?
what is an ETL or ETT? And what are the different types?
