Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15801 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
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what are the data modeling tools you have used?(polaris)
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
