Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 14518 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
duplicate records can be eliminated the following ways:
1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
what is different between sequential batch and concurrent batch and which is recommended and why?
explain the methodology of Data Warehousing?(Polaries)
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what is pmrep command?
What are the steps involved in etl process?
What is initial load and what is full load?
What is partitioning? Explain different types of partitioning?
Explain what is etl process? How many steps etl contains explain with example?
how do u set partition points in the mapping?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What are your responsibilities as an etl tester?
dimension object created in oracle can be imported in designer?how?
What is a mapping?
How many steps etl contains explain with example?
