adspace


Eliminating of duplicate records without using dynamic lookups

Answer Posted / raghav

with out distinct we can do it in 3 possible ways.

1. Using Group by function which will act like a distinct in
TD13.0 database

2. using SET table concept, like first we create the multi
set table and insert the duplicate rows into them and then
create the set table and use the insertselcet concept, in
this case only distinct rows will be inserted.

3. use rowid, derived table or sub query concept then we can
do this

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the data modeling tools you have used?(polaris)

2073


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4203


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2114


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1782