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