Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7641 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
How many steps etl contains?
How to fine tune mappings?
where we cannot use sorter Transformation. if we use then we will not get correct data?
how would u estimate the size of Aggregator transform data and index cache?
What is staging area referring to?
tell me few points when u become TL
what is the use of server?
What is tracing level and what are the types?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is a lookup table in etl?
What are the modules in Power Mart?
What is a mapping, session, worklet, workflow, mapplet?
When do we go for the tools in the market?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
